Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Money( MyAmount/1000000000000,'$#,##0') & 'T'
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')
If you use number formatting 'Auto' on your measure it will abbreviate but you won't get the $ sign