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);
