topic Change currency symbol depending on variable value in QlikView

Change currency symbol depending on variable value

salto — Wed, 29 Sep 2010 18:35:59 GMT

Hello,

I have a variable (Currency) that lets me select to show the sales amount in € or $ in a chart.

It works fine, but, can I change the currency symbol in the charts? The number format pattern is set to €. So it is always showing €. Is it possible to change depending on the value of the Currency variable?

Many thanks in advance.

Change currency symbol depending on variable value

Wed, 29 Sep 2010 18:48:03 GMT

Hello,

on the Number Tab of a chart there is a 'Symbol' entry field. Here you can enter expressions to define the symbol shown on the axes.

hth,
Thilo

Change currency symbol depending on variable value

pover — Wed, 29 Sep 2010 18:48:09 GMT

You could get rid of the symbol in the number format and put the expression =only(Currency) in the Symbol field in the same tab.

Regards.

Change currency symbol depending on variable value

boorgura — Wed, 29 Sep 2010 19:44:22 GMT

You can get the value of the selection into a variable (say vTemp)

then set the number format of that expression to "Expression Default"

In the expression use the num() function.

num(<expr>, '$(vTemp) #,##0')

Let me know if you have any questions.

Change currency symbol depending on variable value

salto — Thu, 30 Sep 2010 10:49:38 GMT

Thank you Thilo, Karl,

I have tried filling the Symbol field before posting, but had no result. I have tried with this expression:

=if($(Currency) = 'Euro', '€', '$')

It is showing nothing after the Sales Amount. Does it have any incorrection? Or do I have to select a Number Format other than Money?

Thanks again.

Change currency symbol depending on variable value

salto — Thu, 30 Sep 2010 10:57:18 GMT

Thank you Rocky, it is a bit longer than filling the symbol field, but it works perfectly.

Re: Change currency symbol depending on variable value

francesco_menin — Wed, 17 Sep 2014 11:30:20 GMT

The symbol field is not available in pivot / straight tables, so shouldn't it be done via the Num() func anyway?

Re: Change currency symbol depending on variable value

Anonymous — Thu, 25 Jun 2015 14:07:18 GMT

Hi Rocky Could you please elaborate with an example, how to pass a variable from list box selections where it reflects in the chart

John