how to change number displayed on a graph?

[#1]

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

[Gysbert_Wassenaar]

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

[swuehl]

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]

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