Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
h_prakash
Creator II
Creator II

Number Format in Qlik Sense

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

7 Replies
sunny_talwar

It looks like a huge number, what do you want to see this as?

h_prakash
Creator II
Creator II
Author

Thanks Sunny for responding. I want to see six digits after decimal.

Thanks

Hari

sunny_talwar

May be this

Num(Sum({<Status={'Active'}>}FinanceAmount/Exchange Rate)/1E15, '#.#####')

h_prakash
Creator II
Creator II
Author

Hi Sunny I am able to remove the e+15 from the KPI. But when I set it to auto format it is not saying Millions or Billions.(with Notations M,G). Can You Please help..?

sunny_talwar

Won't be able to help you with this... there are a lot of threads about number formatting in Qlik Sense... check them out. I have not played around with this much to be able to help

h_prakash
Creator II
Creator II
Author

Sure Np Sunny. Thanks for responding.

ruanhaese
Partner - Creator II
Partner - Creator II

I realize this is way late but for anybody finding this thread later on

to get the "e15" bit gone in Qlik Sense number formatting just add a 0

eg  "#"  becomes "#0"