
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense auto num format always one decimal
Hi community,
I'm using Qlik Sense April 2018 and I want to use auto format, with auto unit, but the number of decimal change every time .
It's possible to ALWAYS limit to one decimal ?
Thanks,
Aurélien
PS: I don't want a expression with multi num()
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May you can define your Measure like this:
if(Sum(Sales) > 1000000, num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),
if(Sum(Sales) > 1000, num(Sum(Sales)/1000, '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))
'#.##0,##M'
'#.##0,##K'
Then data will align to the above format.
Or
Select Number or Money format, modify the format like below:
if(Sum(Sales) > 1000000, num(Sum(Sales)/1000000, '#.##0,##M', ',', '.'),
if(Sum(Sales) > 1000, num(Sum(Sales)/1000, '#.##0,##K', ',', '.'), num(Sum(Sales), '#.##0,##', ',', '.')))
'#.##0,##M'
'#.##0,##K'


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
could you show your expected result in chart object ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In this chart I have 2 decimals, but I want one (and keep auto unit)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, but I would like to find another way


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i guess you can't, why you don't use the custom number formatting ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When I display the data of the Group it's in billion and for subsidiary it's in million or in kilo. With custom formatting I'm losing this functionality.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it's so easy to do that in PowerBI, I don't know why Qlik is not doing anything about it
We want to take advantage of the auto unit changing and at the same time being able to define the number of decimal places to be used. Has anyone found a solution yet?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Choice Measure expression
And insert the expression:
Dual(Num(Sum(Sales)/Pow(10,3*(Div(Log10(Sum(Sales)),3))),'#.##0,0')&pick(div(Log10(Sum(Sales)),3),'k','M','B','T'),Sum(Sales))
I hope helps.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The format should be '#,##0.0'

- « Previous Replies
-
- 1
- 2
- Next Replies »