how to convert default numberics into indian.

[Anonymous]

Hi Everyone,

i have created an app in qliksense with default standards, But i want this for my Indian Customers , Please help me for converting the count in Indian standards

The default format is - > SET MoneyFormat='$#,##0.00;($#,##0.00)';

and its coming in the below formats :

i want in lac/ crore

Kindly assist.

[abhaysingh]

Hi,

Simple Way is create one variable at Backend using Let and use it in Your Expression..

Thanks..

[Anonymous]

Hi Abhay,

Thnks for the quick replay,

Can you please explain in detail, as i am new to qliksense.:(

[abhaysingh · Accepted solution]

Just go to backend script, and make a variable

let vlacs= 100000

and use it in your expression

sum(Sales)/vlacs

thanks

hope it helps

[Anonymous]

Thnks Abhay,

it works .

One more thing , is it possible to put Indian currency symbol here in qliksense ?

[phaneendra_kunc]

update your moneyformat with this in your script.

SET MoneyFormat='₹#,##0.00;(₹#,##0.00)';

[Anonymous]

Hi,

i am not getting it

SET MoneyFormat='₹#,##0.00;(₹#,##0.00)';

this boxes are hiding the symbol i think

[phaneendra_kunc]

Are you using "Money" as format or you are using "Number"?

Change your number format to "Money" in the KPI object.

Or else you can do this too..

=Num(sum(sales)/vLac , '₹#,##0')