Definition for auto num format

[zhaohaifeng]

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

[YoussefBelloum]

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]

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