Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello Arjun,
Check Settu's reply in the below link.
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'))
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.
Hello,
Reminder to please mark the correct answer or helpful.
Qlik Community Tip: Marking Replies as Correct or Helpful
Thanks.