Help with 'Num' function

[#1]

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!

[sivarajs · Accepted solution]

Put a brace that enclosing sum followed by num function

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

[er_mohit]

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

[#4]

Hi,

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

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

u ll get the same format as u written in expression

[#5]

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

[#6]

Thank you! It works