This content has been marked as final. Show 5 replies
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:
= I have tried:
=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,