6 Replies Latest reply: Nov 16, 2017 12:43 PM by Hari Nag RSS

    Number Format in Qlik Sense

    Hari Nag

      Hello Qlik Experts,

      I am trying to create a KPI in Qlik Sense with Expression Sum({<Status={'Active'}>}FinanceAmount/Exchange Rate). This FinanceAmount/Exchange Rate has to be in the Front end as the Exchange Rate is to be dynamic according to the selections.

      As I create KPI it is showing value as 9.05P in the Auto format. When I keep as full number it is giving scientific notation as 9.042356790876e+15. I tried round and ciel but it is not working. Can you please help me in this regard.

       

      Thanks

      Hari