Number Formatting in Thousands,Lacs,Crores,Millions

[ishansjain2095]

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.

[ishansjain2095]

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

[petter · Accepted solution]

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

[ishansjain2095]

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]

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

[petter]

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