topic Re: How to convert default number formatting into Crores(Cr) and Lakhs(L) in QlikSense? in App Development

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

suryanksingh — Sat, 25 Mar 2017 11:00:49 GMT

Does anyone know how to customize number formatting in QlikSense ?

By default QlikSense displays numbers in format given below:

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

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

Anonymous — Tue, 28 Mar 2017 13:18:46 GMT

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

suryanksingh — Wed, 29 Mar 2017 10:23:29 GMT

Thanks @Ajit,

Could you help me with an example?

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

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