topic Currency number formatting in QlikView

Currency number formatting

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

Hi,

I would like to know if there is any chance in QV to format the currency number on dashboard for different countries by selecting the country in the drop down or any kind of selection.

Eg: When I select USA in the drop down then I should see the currency value 100.00 ( Dot after 100)

If I select Mexico in the drop down then I should see the currency value 100,00 (Comma after 100)

FYI Both the values are same just the comma and dot should be different

Thanks in Advance.

Re: Currency number formatting

Anil_Babu_Samineni — Fri, 19 Jan 2018 18:39:35 GMT

There is nothing formula for that? You may use If..Else condition or Pick(Match()) only

Pick(Match(Country, 'USA','Mexico'), Num(Sum({<Country = {'USA'}>} Sales), '#,##0'), Num(Sum({<Country = {'Mexico'}>} Sales), '#.##0'))

Re: Currency number formatting

CVR — Fri, 19 Jan 2018 18:51:58 GMT

Thanks for your reply!

I have almost 15 countries in my list and there are 10 different fields and one among them is currency. Will the above script works with this scenario?

Thanks in Advance