Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think it can - see how to use the Num() function with format specification like I just did in Qlik Sense:
Any way to use number formatting "FORMAT" in expression editor????
I think it can - see how to use the Num() function with format specification like I just did in Qlik Sense:
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) &
Can you show me the result in M as Millions, Cr as Crores, Lac as Lacs.
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';