Re: Qliksense number formatting auto concerns - Qlik Community

zhaohaifeng · ‎2018-06-27

Hi Folks,

For Number formatting auto, i have some concerns.

Condition : we used auto number formatting.

First, for chart, i saw just used if/pick we can get the G/M, if not , the auto num is 1,000 format.

Second, for table, i saw we cant get M/G for auto number format, we need to use script to achive it.

So my concerns is that for Chart and table, whats the logic for auto number format works?

Please let me know if i missed something. Thanks in advance.

Best Regards,

Haifeng

balabhaskarqlik · ‎2018-06-28

May be this:

For Charts:

Number formatting:

Auto: Qlik Sense automatically sets a number formatting based on the source data.

To represent numeric abbreviations, the international SI units are used, such as k (thousand), M (million), and G (billion).

Refer the link:

For Table:

Number formatting:

Auto: Qlik Sense automatically sets a number formatting based on the source data.

Refer the link:

Because of the, International SI units are not used/defined for Table, we need to add the formatting in script level itself.