Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. !
Hi Suryank,
Did you try using the standard Format function ? I believe it should work for your case.
Let me know if you face any problems.
thanks,
Ajit
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.