5 Replies Latest reply: Nov 2, 2017 12:55 PM by Aehman K RSS

    Formatting Numbers in a KPI - Qliksense

    Darryn Varner

      Hi There

       

      I am using the same structured calculation as below and it works 100% in a flat table, as soon as you use it in a bar chart or KPI etc the numbers show but the symbol gets dropped for some reason.

       

      if(Sum(Sales) > 1000000,  num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),

          if(Sum(Sales) > 1000, num(Sum(Sales)/1000,  '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))

       

      Using Auto or custom Formatting is not an option as I need to dictate to the calculation at what points I want what symbols.

       

      Any ideas how to do this?