Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
xlitzdrama
Creator
Creator

Custom Number Formatting in charts

Custom Formatting is ##,##,##,##,##,##0 when used for any measures in charts it is showing as 1+e....... in the axis rather than the number.

xlitzdrama_0-1661506957927.png

 

 

 

Labels (3)
7 Replies
vikasmahajan

Hi,

While creating measures have you keep auto option ?

vikasmahajan_0-1661513673538.png

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
xlitzdrama
Creator
Creator
Author

No Auto Formatting is used.

deepanshuSh
Creator II
Creator II

You can just reduce the ##,##,##,##,##,##0 to ##,##0 it would give out the correct result. Whats happening is that the e = 100000, resulting in 1+e depiction. 

Trial and error is the key to get unexpected results.
xlitzdrama
Creator
Creator
Author

Need to use Indian Number System and not International one

marcus_sommer
MVP & Luminary
MVP & Luminary

It should work with something like:

num(10000000000, '##,##,##,##,###','.', ',')

If your numbers are bigger as the number of #respectively 0 within the format-code it showed the output as 1e... Important by num() is further that the decimal- and thousand-parameters are also set.

- Marcus

 

xlitzdrama
Creator
Creator
Author

Nope, it's not working issue is same

 

marcus_sommer
MVP & Luminary
MVP & Luminary

For me it worked fine in QlikView and therefore I would expect the same in Sense. To check it create a new dummy-app with inline dummy-data with around two dozens of different length numbers and put them with such format-pattern within the properties and/or per num() into a table-chart and a different bar/line-chart. How does it look like then?

- Marcus