Qlik Sense and formatting

sri_c003 — Thu, 30 Nov 2017 16:58:25 GMT

Scenario:

Load Script:

SET vLocale = 'EN';

SET MoneyFormat = '$#,##0.00;($#,##0.00)'; // defaults to EN

IF '$(vLocale)' = 'ES' THEN

SET MoneyFormat = '€ #.##0,00;-€ #.##0,00';

END IF

Then I created a page, and created a few money fields.

Loaded data, and all worked fine!

So far, so good...

And then I changed the vLocale to ES.

Loaded the app and reloaded the data...

Money format updated to ES format.

But... the fields i had created on the sheet with money, still show old formatting. Seems like Qlik Sense hard codes the money (for this matter, date too) as a hard coded string, rather than taking it from the variable.

This is counter productive, cos I would need to go to every created field, and manually change them to auto/money again to update the formatting string.

Is there any other way of doing this where I can update the displayed format on the fly.

I do not want to go and type an expression in the data field, that option is ruled out. There are heavy calculations going on there already, and would prefer a non intrusive approach.

topic Qlik Sense and formatting in App Development

Qlik Sense and formatting