Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to represent Number format Money

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

7 Replies
Not applicable
Author

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.

Not applicable
Author

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

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
MarcoWedel

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;

QlikCommunity_Thread_38556_Pic4.JPG.jpg

QlikCommunity_Thread_38556_Pic5.JPG.jpg

regards

Marco

lakshmikandh
Specialist II
Specialist II

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

Not applicable
Author

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

MarcoWedel

Please don't add new questions to other's threads.

Instead create a new thread for your question.

thanks

regards

Marco