Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Currency Symbol display

=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.

1 Solution

Accepted Solutions

Re: Currency Symbol display

Check out the attached qvw

View solution in original post

8 Replies

Re: Currency Symbol display

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')))))

Not applicable

Re: Currency Symbol display

Thank you but it is displaying values as 3876964.4687334

Re: Currency Symbol display

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

Not applicable

Re: Currency Symbol display

I have set varCurrencySymbol to maxstring(CurrencySymbol)

I see the above imagecurrency.PNG

Re: Currency Symbol display

Check out the attached qvw

View solution in original post

Not applicable

Re: Currency Symbol display

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

Re: Currency Symbol display

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

Not applicable

Re: Currency Symbol display

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