topic Re: Currency Symbol display in QlikView

Currency Symbol display

Tue, 02 Feb 2016 12:34:32 GMT

=If( GetSelectedCount( LuCurrencyType3 )>0,

num(sum(IF([Month of Expense]=MONTH(Today()),

IF([Year of Expense]=YEAR(Today()),[Expense Amount (USD)]/Factors,varCurrencySymbol& ' '& '#,#00.0' ))))

, num(sum(IF([Month of Expense]=MONTH(Today()),

IF([Year of Expense]=YEAR(Today()),[Expense Amount (USD)],varCurrencySymbol& ' '& '#,#00.0')))))

I have the above expression I am not able to get the currencysymbol working.Also,in Number I have set to expression default,but still it is not defaulting to single decimal.

varCurrencySymbol has list of different currency symbols (in text format)

Thank you.

Re: Currency Symbol display

sunny_talwar — Tue, 02 Feb 2016 12:38:09 GMT

Can you try this:

=If(GetSelectedCount(LuCurrencyType3) > 0, Num(Sum(If([Month of Expense] = Month(Today()),

If([Year of Expense] = Year(Today()), [Expense Amount (USD)]/Factors, '$(varCurrencySymbol)#,#00.0')))),

Num(Sum(If([Month of Expense] = Month(Today()),

If([Year of Expense] = YEAR(Today()), [Expense Amount (USD)], '$(varCurrencySymbol)#,#00.0')))))

Re: Currency Symbol display

Tue, 02 Feb 2016 12:44:40 GMT

Thank you but it is displaying values as 3876964.4687334

Re: Currency Symbol display

sunny_talwar — Tue, 02 Feb 2016 12:46:40 GMT

What do you see when you put $(varCurrencySymbol) in a text box object?

Re: Currency Symbol display

Tue, 02 Feb 2016 13:02:03 GMT

I have set varCurrencySymbol to maxstring(CurrencySymbol)

I see the above image

Re: Currency Symbol display

sunny_talwar — Tue, 02 Feb 2016 13:53:25 GMT

Check out the attached qvw

Re: Currency Symbol display

Tue, 02 Feb 2016 20:10:26 GMT

Awesome.Thank you very much.Really appreciate your help ,patience and willingness to help.Stay blessed

Re: Currency Symbol display

sunny_talwar — Tue, 02 Feb 2016 20:12:10 GMT

Not a problem. Just curious to know what were you doing differently that was not working in your application initially?

Re: Currency Symbol display

Wed, 03 Feb 2016 16:12:13 GMT

The close parenthesis for Num(sum( was not placed appropriately.