Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

zhaohaifeng
New Contributor III

Qliksense number formatting auto concerns

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

Tags (1)
1 Reply
balabhaskarqlik
Honored Contributor

Re: Qliksense number formatting auto concerns

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:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Visualizations/LineChart/line-cha...

For Table:

Number formatting:

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

Refer the link:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Visualizations/Table/table-proper...

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

Community Browser