5 Replies Latest reply: Feb 8, 2013 7:30 AM by flawrence RSS

    Help with 'Num' function

      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!