Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gauravgs
Contributor

how to convert default numberics into indian.

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.

1 Solution

Accepted Solutions
abhaysingh
Contributor III

Re: how to convert default numberics into indian.

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

7 Replies
abhaysingh
Contributor III

Re: how to convert default numberics into indian.

Hi,

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

Thanks..

gauravgs
Contributor

Re: how to convert default numberics into indian.

Hi Abhay,

Thnks for the quick replay,

Can you please explain in detail, as i am new to qliksense.Smiley Sad

abhaysingh
Contributor III

Re: how to convert default numberics into indian.

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

gauravgs
Contributor

Re: how to convert default numberics into indian.

Thnks Abhay,

it works .

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

phaneendra_kunc
Valued Contributor III

Re: how to convert default numberics into indian.

update your moneyformat with this in your script.

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

gauravgs
Contributor

Re: how to convert default numberics into indian.

Hi,

i am not getting it

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

this boxes are hiding the symbol i think

phaneendra_kunc
Valued Contributor III

Re: how to convert default numberics into indian.

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')