Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ishansjain2095
Creator
Creator

Number Formatting in Thousands,Lacs,Crores,Millions

Hi All,

Facing an issue in number formatting using 'Number' as Simple-'1,000' format. Can anyone help me how can I use number formatting in expression editor using Text and Image Chart.

Labels (1)
1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

I think it can - see how to use the Num() function with format specification like I just did in Qlik Sense:

Merknad 2020-02-11 100100.png

View solution in original post

5 Replies
ishansjain2095
Creator
Creator
Author

Any way to use number formatting "FORMAT" in expression editor????

petter
Partner - Champion III
Partner - Champion III

I think it can - see how to use the Num() function with format specification like I just did in Qlik Sense:

Merknad 2020-02-11 100100.png

ishansjain2095
Creator
Creator
Author

Hi Petter,

How can I use num() function in below expression any idea?????

'Sales: ' &
(
sum({< Date ={">=$(vMonthStart) <= $(vMonthEnd)"},[Month]= >}GrossSale)
+
sum({< Date ={">=$(vMonthStart) <= $(vMonthEnd)"},[Month]= >}ReturnSale)
)
&','& Chr(10) &

ishansjain2095
Creator
Creator
Author

 Can you show me the result in M as Millions, Cr as Crores, Lac as Lacs.

petter
Partner - Champion III
Partner - Champion III

In Qlik Sense you can set the NumericalAbbreviation environment variable like this adding 5:Lac and 7:Cr like this:

 

SET NumericalAbbreviation='3:k;5:Lac;6:M;7:Cr;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';