Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (2)
3 Replies

Re: how to change number displayed on a graph?

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: how to change number displayed on a graph?

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')

bellamae
Valued Contributor

Re: how to change number displayed on a graph?

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

Capture11.PNG

Capture12.PNG

Community Browser