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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Reko_freed
Contributor III
Contributor III

Display numbers as billion, million or lakhs while creating charts

While crating charts, I want to show numbers as -

1000000000 - 1B

1000000 - 1M

100000 - 1L

10000 - 10K

Suppose I am using a measure like  - = Sum(sales)

Please help me to get my desired output, I am new to Qlik sense.

Labels (4)
1 Reply
mansoorsheraz
Creator
Creator

Try by keeping the "Number Formatting" option of the measure as "Auto"

mansoorsheraz_0-1668194497951.png


This works for me in the graphs:

mansoorsheraz_1-1668194536584.png


Hope it works for you too.

Thanks.