Discussion Board for collaboration on QlikView Layout & Visualizations.
I searched through the forum but could not find a right answer to represent number format money in thousands (K) Million (M) and Billions (B) Anyone had success with that?
Thanks for your reply. That certainly helps. But I watnt hsi Moey format in a pie chart, so I want to know how to use format symbols for Million, Billion representation for Money number type.
Num(<expression>/1000000,'$ #,##0.00 (M)')
Num(<expression>/1000000000,'$ #,##0.00 (B)')
You can't use negative values in pie chart..so need for negative symbol representation for money
Hope it helps
might be a bit late
but maybe also helpful:
SET vSize = Div(Log10($1),3);
SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0')&' '&Pick($(vSize($1)),'K','Mil','Bil','Tril'),$1);
$(vFormatNumber(parameter)) as paramFormat;
LOAD pow(10,Rand()*14) as parameter