Currency units formatting

[CVR]

Hi,

I want to know if there is any chance in QlikView to display currency formatting on the dashboard based on a country selection in drop down or something?

Eg:  USA: 100.00   (There is a dot after 100)

         Mexico : 100,00 ( There is a coma after 100)

Both the values are same.

Thanks in Advance

[devarasu07]

what is the usage of this kind requirement? not clear

also have tried this way

if(Country='USA', Num(CCY,'#,##0.00')

,Num(CCY,'###0,00'))

[vamsee]

Hi Arjun,

To achieve this you have to create a table (either inline or excel) with three columns and join it to FACT table using currency column / Country column.

Country	Currency	Format
US	USD	$#,##0.00;($#,##0.00)
France	EUR	€#,##0.00;(€#,##0.00)

In all the expressions of the charts in UI use the following code.

Num(EXPRESSION,Only( Format))

In the number section use expression default.

NOTE: As you want to give the user an ability to see data in two currencies you have to convert the data using an exchange rate back end. Doing this in the charts might cause performance issues.

[vamsee]

Hello,

Reminder to please mark the correct answer or helpful.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks.

[tamilarasu · Accepted solution]

Hello Arjun,

Check Settu's reply in the below link.

https://community.qlik.com/thread/224024#1077812