topic Re: Help with 'Num' function in QlikView

Help with 'Num' function

Fri, 08 Feb 2013 10:45:19 GMT

Hi Qlikview Community,

a simple question from a Qlikview newbie: how do I use the num funtion when I'm combining with sum if?

The following part works:

sum(if(Status = 'Closed', [One Off Charge])) resulting in 20158.36, which I would like to format into currency:

I have tried:

=num(sum(if(Status = 'Closed', [One Off Charge], '£#,##0'))) which tells me 'Expression OK' but does not change the result into the format I would like.

Help and explanation would be greatly appreciated,

Thank you!

Re: Help with 'Num' function

sivarajs — Fri, 08 Feb 2013 10:50:26 GMT

Put a brace that enclosing sum followed by num function

num(sum(if(Status = 'Closed', [One Off Charge])),'£#,##0')

Re: Help with 'Num' function

er_mohit — Fri, 08 Feb 2013 12:05:57 GMT

i think you close the bracket in last in your script try this.

=num(sum(if(Status = 'Closed', [One Off Charge])), '£#,##0')

rest of syntax is perfect...

Re: Help with 'Num' function

Fri, 08 Feb 2013 12:18:59 GMT

Hi,

In Chart Properties ------------> Number tab

and Enable----------> Expression Default

u ll get the same format as u written in expression

Re: Help with 'Num' function

Fri, 08 Feb 2013 12:26:33 GMT

My apologies! I think I had missed off the '=' - it works Thank you!

Re: Help with 'Num' function

Fri, 08 Feb 2013 12:30:41 GMT

Thank you! It works