-
Re: How to represent Number format Money
Kiran Rokkam Jul 20, 2012 12:53 AM (in response to Sunil 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.
-
Re: How to represent Number format Money
Sunil Rodrigues Jul 20, 2012 2:53 PM (in response to Kiran Rokkam )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
-
Re: How to represent Number format Money
Mayil Vahanan Ramasamy Jul 20, 2012 3:24 PM (in response to Sunil 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
-
-
-
Re: How to represent Number format Money
Marco Wedel Jul 1, 2014 6:50 AM (in response to Sunil Rodrigues )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
-
QlikCommunity_Thread_38556.qvw 157.0 K
-
-
Re: How to represent Number format Money
Lakshmikandh Karthikeyan Sep 27, 2016 3:44 PM (in response to Sunil Rodrigues )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
-
Re: How to represent Number format Money
Sai Krishna Nov 7, 2016 6:37 AM (in response to Sunil Rodrigues )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
-
Re: How to represent Number format Money
Marco Wedel Nov 7, 2016 4:02 PM (in response to Sai Krishna)Please don't add new questions to other's threads.
Instead create a new thread for your question.
thanks
regards
Marco
-