topic Number Formatting - Thousands,Millions in QlikView

Number Formatting - Thousands,Millions

rxp03570 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 05 Apr 2018 18:39:16 GMT

rxp03570 — Thu, 05 Apr 2018 18:49:31 GMT

Looking for Negative numbers as well

boorgura — Thu, 05 Apr 2018 19:11:23 GMT

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 — Thu, 05 Apr 2018 21:34:00 GMT

maybe helpful:

regards

Marco