Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to convert "$2,00,000" into "INR200k" in a table or pivot table in qlik sense ?
Edit the current expression and multiple it by the exchange rate...
Something tells me you are looking for another answer.
I want to show this data "$2,00,000" in this format "INR200k" in a table or pivot table in qlik sense , how would i do it.
Set the Number Formatting to Money and after that change the Format pattern (found directly underneath it) to this:
INR#.##0;INR-#.##0
This will change the currency to INR. I do not know how to change it to K.
If the whole application is in INR, consider changing the MoneyFormat in the script (one of the first SET statements).
Go to Data>your measure column>Number formatting>select Money>Format Pattern> INR ###k