Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zhaohaifeng
New Contributor III

Definition for auto num format

Dear all,

In Qliksense, such as bar chart, if we set the auto num format for values, some time the value have 1 decimal digit only (such as 1.2G), some time have two decimal digit (such as 1.23G). So i dont know the logic, can we control the decimal dight? For explame, we just want to reserve one decimal digit, How to achive? If cant achive, what s the logic? When display 1 decimal digit(1.2G), when displat 2 decimal digit(1.23G).

Thanks for your help in advance.

Best Regards,

Haifeng

2 Replies
YoussefBelloum
Esteemed Contributor

Re: Definition for auto num format

Hi,

take a look at this:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVar...

It is a brand new feature present on the last release of qliksense, maybe it can help you

Otherwise, you can use the num() function, take a look at the help to understand how it works

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/FormattingFunc...

zhaohaifeng
New Contributor III

Re: Definition for auto num format

Youssef Belloum 撰写:

Hi,

take a look at this:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVar...

It is a brand new feature present on the last release of qliksense, maybe it can help you

Otherwise, you can use the num() function, take a look at the help to understand how it works

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/FormattingFunc...

Thanks Man.

But our Qs version not the latest version, so we cant use your first suggestion.

And also we want to export the data as full num format and G/M format in Qs site, so the num() function not achieve it, now i think in this case we just can use auto num format. Do you know the logic for auto num format? When display 1 decimal digit(1.2G), when displat 2 decimal digit(1.23G). Thanks again for your help.

Best Regards,

Haifeng