Discussion board where members can get started with Qlik Sense.
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.
May be this:
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:
Because of the, International SI units are not used/defined for Table, we need to add the formatting in script level itself.