topic Re: Currency units formatting in QlikView

Currency units formatting

CVR — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Currency units formatting

devarasu07 — Tue, 23 Jan 2018 18:38:36 GMT

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

Re: Currency units formatting

vamsee — Tue, 23 Jan 2018 19:05:30 GMT

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.

Re: Currency units formatting

vamsee — Fri, 09 Mar 2018 15:41:35 GMT

Hello,

Reminder to please mark the correct answer or helpful.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks.

Re: Currency units formatting

tamilarasu — Fri, 09 Mar 2018 16:05:46 GMT

Hello Arjun,

Check Settu's reply in the below link.

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