Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Rodrigues
HI,
If you are not using straight table, use format symbols.
For straight table you need to change the expression to include formating. Num(<expression>/1000,'$ #,##0.00 K')
Kiran.
Hi Kiran,
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.
Thanks,
-Rodrigues
HI,
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);
LOAD *,
$(vFormatNumber(parameter)) as paramFormat;
LOAD pow(10,Rand()*14) as parameter
AutoGenerate 30;
regards
Marco
Hi,
You can change the auto number formatting symbol from "G" to "B" in javascript
Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'
Thanks,
Lakshmikandh
Hi team,
Anyone got solution for this, I am facing similar issue.
Money format is working fine in bar chart but not in pie chart. i am using QV11SR9.
Regards,
Sai
Please don't add new questions to other's threads.
Instead create a new thread for your question.
thanks
regards
Marco