topic Re: conversion currency in QlikView

conversion currency

Thu, 02 Jun 2016 12:33:35 GMT

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

oknotsen — Thu, 02 Jun 2016 13:07:10 GMT

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

Something tells me you are looking for another answer.

Fri, 03 Jun 2016 07:45:08 GMT

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 — Fri, 03 Jun 2016 08:22:50 GMT

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 — Fri, 03 Jun 2016 08:34:50 GMT

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