Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amartinez35
Valued Contributor

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()

6 Replies
balabhaskarqlik
Honored Contributor

Re: Qlik Sense auto num format always one decimal

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'

agigliotti
Honored Contributor II

Re: Qlik Sense auto num format always one decimal

could you show your expected result in chart object ?

amartinez35
Valued Contributor

Re: Qlik Sense auto num format always one decimal

In this chart I have 2 decimals, but I want one (and keep auto unit)

nop.PNG

amartinez35
Valued Contributor

Re: Qlik Sense auto num format always one decimal

Thank you, but I would like to find another way

agigliotti
Honored Contributor II

Re: Qlik Sense auto num format always one decimal

i guess you can't, why you don't use the custom number formatting ?

amartinez35
Valued Contributor

Re: Qlik Sense auto num format always one decimal

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.

Community Browser