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

[suryanksingh]

Does anyone know how to customize number formatting in QlikSense ?

By default QlikSense displays numbers in format given below:

Amount	International Quotation
100,000.00	100 K
1,000,000.00	1 M
10,000,000.00	10 M
100,000,000.00	100 M
1,000,000,000.00	1 G

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

International Quotation	Amount	Indian Quotation
100 K	100,000.00	1 L
1 M	1,000,000.00	10 L
10 M	10,000,000.00	1 Cr
100 M	100,000,000.00	10 Cr
1 G	1,000,000,000.00	100 Cr

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

[Anonymous]

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

[suryanksingh]

Thanks @Ajit,

Could you help me with an example?

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

Default	Amount	Indian Quotation
100 K	100,000.00	1 L
1 M	1,000,000.00	10 L
10 M	10,000,000.00	1 Cr
100 M	100,000,000.00	10 Cr
1 G	1,000,000,000.00	100 Cr

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