Number Formatting - Thousands,Millions

[rxp03570]

Trying to format and represent this format in straight table. The below expression doesn't help

=if(Sum(Value) > 1000000,  num(Sum(Value)/1000000, '#.##0,##M', ',', '.'),

if(Sum(Value) > 1000, num(Sum(Value)/1000,  '#.##0,##K', ',', '.'), num(Sum(Value), '#.##0,##', ',', '.')))

Any inputs please.

[MK_QSL]

Scaling Numbers and DSE Tips | Qlikview Cookbook

[rxp03570]

Looking for Negative numbers as well

[boorgura · Accepted solution]

SET vScaleNumber=if(fabs($1)>1E6, num($1/1E6,'$#,##0.000M')

,if(fabs($1)>1E3, num($1/1E3,'$#,##0.000K')

,num($1,'$#,##0')

));

this should do it for negative numbers.

[MarcoWedel]

maybe helpful:

Re: Number formatting - millions to billions

regards

Marco