conversion currency

[#1]

How to convert "$2,00,000" into "INR200k" in a table or pivot table in qlik sense ?

[oknotsen]

Edit the current expression and multiple it by the exchange rate...

Something tells me you are looking for another answer.

[#3]

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.

[oknotsen]

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

[Karahs]

Go to Data>your measure column>Number formatting>select Money>Format Pattern> INR ###k