topic Re: Displaying different currencies in QlikView

Displaying different currencies

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

I have a weird request, I am trying to get two different currency symbols for the answer to the true and false.

If the site is Ransomes, I want the answer to be displayed in £ and if it isnt, i want the answer to be displayed in $.

IF(Site='Ransomes', IF(AdminFee=1, 35/60*disruption_time+30, 35/60*disruption_time), (99/60*disruption_time)*employeeCount)

Is this possible?

Re: Displaying different currencies

sunny_talwar — Wed, 18 Jan 2017 15:41:11 GMT

May be this:

If(Site='Ransomes',

Num(If(AdminFee=1, 35/60*disruption_time+30, 35/60*disruption_time), '£#,##0'), Num((99/60*disruption_time)*employeeCount, '$#,##0'))

Re: Displaying different currencies

khaycock — Wed, 18 Jan 2017 15:42:57 GMT

Nope still displays the £ stuff as $

Re: Displaying different currencies

sunny_talwar — Wed, 18 Jan 2017 15:44:17 GMT

If this is in a straight table or any other chart, make sure that you have selected 'Expression Default' on the numbers tab of chart properties for this specific expression

Re: Displaying different currencies

khaycock — Wed, 18 Jan 2017 15:48:41 GMT

Amazing thank you!!!