6 Replies Latest reply: Aug 30, 2016 8:29 AM by Michael King RSS

    Num( Function not working

    Michael King

      Good Morning All,

       

      I have been using the num function without issue in all my Qlik Charts but for some reason I cannot get it to work in the following:

       

      'LY - ' & if (GetCurrentSelections(Year)=2016,

       

      num(Sum({<_YTD_LY={1}>} [Sales total with VAT])

      / Count({<_YTD_LY={1}>} DISTINCT [Sales invoice]), '£#.##'),

       

      num(Sum({<[Year]={"$(=max([Year]-1))"}>} [Sales total with VAT])

      / Count({<[Year]={"$(=max([Year]-1))"}>} DISTINCT [Sales invoice]), '£#.##'),

       

      )


      This does not format the number at all. As a result, instead of £15.42 I instead have 15.419583493 (for example). Also, if it helps, this is under the Subtitle field in Qlik Sense.

       

      I appreciate any assistance you can give me with regards to this issue.

       

      Thank you in advance.

       

      Kind regards,

       

      Michael