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 change number displayed on a graph?

Hi there,

i wanted to know is there to abbreviate $10,000,000,000,000 to $10T on qlik sense as i dont want the graph showing the whole digits i just want it to just display trillions in small abbreviation.

also this is only for one graph so i dont want to be changing everything else on the sheet thank you!

$10,000,000,000,000 to $10T etc

Nazia

3 Replies
Gysbert_Wassenaar

Money( MyAmount/1000000000000,'$#,##0')  & 'T'


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

You may need to use a dual value if you want to use the expression in a chart that expects numeric expression results (like line/bar charts):

=Dual( Money( MyAmount/1000000000000,'$#,##0')  & 'T', MyAmount/1000000000000)


edit:

Or try just

=Money( MyAmount/1000000000000,'$#,##0T')

Anonymous
Not applicable
Author

If you use number formatting 'Auto' on your measure it will abbreviate but you won't get the $ sign

Capture11.PNG

Capture12.PNG