Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

conversion currency

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

4 Replies
oknotsen
Honored Contributor III

Re: conversion currency

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

Something tells me you are looking for another answer.

May you live in interesting times!
Not applicable

Re: conversion currency

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
Honored Contributor III

Re: conversion currency

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

May you live in interesting times!
kshitijas
New Contributor III

Re: conversion currency

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

Community Browser