Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to use Language and Format

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How to use Language and Format

Last Update:

Jul 5, 2021 7:55:30 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 12, 2012 5:11:52 AM

Attachments

In the case of multiple money formats required due to differences in primary languages, Qlik offers workarounds to achieve this.

This article covers one possible solution for QlikView.

 

Environment:

QlikView 

 


Used QlikView Function: Minstring(Language)
Used Variables: LET vLanguage = '=Minstring(Language)';

The necessary data for that can be stored in any source which can be read by QlikView.

Attached you will find a Sample Application on how this works.

 

Resolution:


Using with a QlikView Object:

Use these Expression as Title for Example to include the Language:

=Minstring({<Index = {'LabelName'}>} [$(vLanguage)])



Use these Expression as Title for Example to include the Money Format:

num( sum(Sale)/ [Exchange Rate], Minstring({<Index = {'Mui_MoneyFormat'}>} [$(vLanguage)]),
Minstring({<Index = {'Mui_DecimalSeperator'}>} [$(vLanguage)]), Minstring({<Index = {'Mui_ThousendSeperator'}>} [$(vLanguage)]))



Script part:

/* First we Load the Excel File with the Keywords and Translations */

Translations:
LOAD Index,
     English,
     German
FROM
[Language Support.xlsx]
(ooxml, embedded labels, table is Language);

/* In the next Step we create a Variable which present the current Language eg. German or English  */
LET vLanguage = '=Minstring(Language)';

/* The table which stores the translations load as Crosstable */
Language:
CROSSTABLE (Language, Translation) LOAD
  Index,
     English,
     German
RESIDENT Translations;

/* create a List of all Languages for the Listbox what showing on screen */
LanguageList:
LOAD Language
RESIDENT Language
WHERE Language > 0;

/* At least we delete the old Table  */
DROP TABLE Language;

/* Now we load the Currencies and link them to the Language  */
Currencies:
LOAD Language As %Language,
     [Exchange Rate]
FROM
[MuiLangForData.xlsx]
(ooxml, embedded labels, table is Currency);
Labels (1)
Contributors
Version history
Last update:
‎2021-07-05 07:55 AM
Updated by: