I noticed in the newer versions of Qlik Sense you can use 'Measure Expression' for the Number Formatting
I am working on an International Dashboard with multiple currencies. I will require the user to select a country and therefore only have a single currency.
Can I use this 'Measure Expression' with the num function to format the values in the meaure? In the past this was not easily possible.
Curious about experiences using the num function (num(Amount,'€ #,##0').
What you can do is build two tables. One with all the countries & currencies and one with your factual data. If a users has selected a country, only one currency is left.
Create a Pick( Match() ) function to pick the right currency and put this in a variable. The variable can then be put in the formatting part of the Num() function.
If you have some example data we can give it a try.
What you can do is build two tables. One with all the countries & currencies and one with your factual data. If a users has selected a country, only one currency is left.
Create a Pick( Match() ) function to pick the right currency and put this in a variable. The variable can then be put in the formatting part of the Num() function.
If you have some example data we can give it a try.
