Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to convert default number formatting into Crores(Cr) and Lakhs(L) in QlikSense?

Does anyone know how to customize number formatting in QlikSense ?

By default QlikSense displays numbers in format given below:

AmountInternational Quotation
100,000.00100 K
1,000,000.001 M
10,000,000.0010 M
100,000,000.00100 M
1,000,000,000.001 G


And as per requirement, values needed should be in the format given below:

International QuotationAmountIndian Quotation
100 K100,000.001 L
1 M1,000,000.0010 L
10 M10,000,000.001 Cr
100 M100,000,000.0010 Cr
1 G1,000,000,000.00100 Cr

Has anyone achieved the above format or has implemented above case, please do share the solution or the steps to it. !

2 Replies
Highlighted
Contributor III
Contributor III

Hi Suryank,

Did you try using the standard Format function ? I believe it should work for your case.

Money

Let me know if you face any problems.

thanks,

Ajit

Highlighted
Partner
Partner

Thanks @Ajit,

Could you help me with an example?

I need the number format to be represented in Indian Quotation format as mentioned below.

DefaultAmountIndian Quotation
100 K100,000.001 L
1 M1,000,000.0010 L
10 M10,000,000.001 Cr
100 M100,000,000.0010 Cr
1 G1,000,000,000.00100 Cr

Any example/solution on achieving the Indian quotation format would be great.