Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
peisenrot
Contributor III
Contributor III

digits after dot on KPI with Format "Auto"

hello,

I am using a KPI with the format "Auto" to calculate money. it could be Million or Billion which I want to show. But I would like to have only one digit after the dot. I would like to see e.g. 198.5 M or 45.4 B. But the system makes 2 digits.

where can i change that?

Best regards

Pia 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))

View solution in original post

1 Reply
anat
Master
Master

If(sum(Amount)/1000000000 > 1,Num(sum(Amount)/1000000000,'0.0 B'), Num(sum(Amount)/1000000,'0.0 M'))