topic Re: Currency symbol in QlikView

Currency symbol

Thu, 28 Jan 2016 21:45:32 GMT

=varCurrencySymbol&''&sum(Amount)*sum(ExchangeRate)

I have the above expression in the text object and it is working fine but the same expression is not working in the chart.Any idea why ?

Thank you.

sunny_talwar — Thu, 28 Jan 2016 21:48:38 GMT

Does this along is working -> sum(Amount)*sum(ExchangeRate)?

Thu, 28 Jan 2016 22:00:06 GMT

yes..it is working

sunny_talwar — Thu, 28 Jan 2016 22:03:29 GMT

What is your expression for varCurrencySymbol?

Thu, 28 Jan 2016 22:06:14 GMT

never mind ..I tried below exp and it is wroking fine.

=Num(Sum(Amount)*Sum([ExchangeRate]),varCurrencySymbol &''&'#,##0')

varCurrencySymbol has diff currency symbols.

Thank you very much.

HirisH_V7 — Thu, 28 Jan 2016 22:08:54 GMT

Symbol means is that image?? or Text??

rodri_morales — Fri, 29 Jan 2016 00:17:46 GMT

If varCurrencySymbol is a text maybe you could try this:

=$(varCurrencySymbol)&''&sum(Amount)*sum(ExchangeRate)

or another option:

='$(varCurrencySymbol)'&''&sum(Amount)*sum(ExchangeRate)

jagan — Fri, 29 Jan 2016 01:10:39 GMT

Hi,

Try like this

=Num(sum(Amount)*sum(ExchangeRate), varCurrencySymbol & '#,##0')

Hope this helps you.

Regards,

Jagan.