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!