topic Re: Data labels formatting in QlikView

Data labels formatting

Tue, 27 Oct 2015 15:53:31 GMT

Hi all!

How do I make the data labels show $19.8 M, $18.9 M, and $15.5 M? I can get them to say $19M, $18M, and $15M, but can't figure out how to add the decimal.

Thanks!

Re: Data labels formatting

sinanozdemir — Tue, 27 Oct 2015 17:37:25 GMT

Hi,

This is what I used:

Hope this helps.

Thanks

Re: Data labels formatting

MarcoWedel — Tue, 27 Oct 2015 22:33:10 GMT

Hi,

one solution might be also:

=Dual(Num(Sum(Value)/Pow(10,3*Div(Log10(Sum(Value)),3)),'$#,##0.0')&' '&Pick(Div(Log10(Sum(Value)),3),'K','M','B','T'),Sum(Value))

hope this helps

regards

Marco