7 Replies Latest reply: Nov 18, 2015 10:56 AM by christian juillard RSS

    Format numbers (in Qlik Sense)

    christian juillard

      Hi all

       

      I am trying to format a number like # ##0 M€

       

      I have 2 objects where I divide expression value like :  sum(field) / 1000000

       

      - in the KPI object I used the custom number to set it up but the result I got for 3 227 200 000 is 322 7 M€  (note the blank place is not a mistake)

      >> What I want is  3 227 M€

       

      - in a pivot table I used the Money number format and I get  3 227,20€

      >> What I want is to set a money format without decimal like 3 227 M€

       

      thank you for your help

      juju