Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

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

 

 

 

Thanks & Regards,
Please Accepts as Solution if it solves your query.
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 & like it.
If you want to go quickly, go alone. If you want to go far, go together.
neerajthakur
Creator III
Creator III
Author

No Auto Formatting is used.

Thanks & Regards,
Please Accepts as Solution if it solves your query.
deepanshuSh
Creator III
Creator III

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.
neerajthakur
Creator III
Creator III
Author

Need to use Indian Number System and not International one

Thanks & Regards,
Please Accepts as Solution if it solves your query.
marcus_sommer

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

 

neerajthakur
Creator III
Creator III
Author

Nope, it's not working issue is same

 

Thanks & Regards,
Please Accepts as Solution if it solves your query.
marcus_sommer

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