Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist II
Specialist II

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

View solution in original post

7 Replies
abhaysingh
Specialist II
Specialist II

Hi,

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

Thanks..

Anonymous
Not applicable
Author

Hi Abhay,

Thnks for the quick replay,

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

abhaysingh
Specialist II
Specialist II

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
Not applicable
Author

Thnks Abhay,

it works .

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

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

update your moneyformat with this in your script.

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

Anonymous
Not applicable
Author

Hi,

i am not getting it

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

this boxes are hiding the symbol i think

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

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