Bar Chart Color by Expression

[shayd]

Hi,

I'm using 'color by expression' over 'bar chart' to add a measure, this measure needs to be a percentage.
In the image below for example, I would like to have a percentage sign beside the number.


This is where the code located:

I've tried using the num function:

=num(((Sum(Invoice_Sum)/(Sum(Income_Target)))-1)*100, '#,##0%' )

But it doesn't work, any suggestions?

Thanks!

[Dalton_Ruer]

Override the Tooltip with your own Custom Tooltip. 

[shayd]

Could you explain furthermore please?

[Dalton_Ruer]

Without any modification the tooltip you get when you hover is based on your measures and color expressions as you saw. 

In my example I have a single measure for the # of Events. 

But if you turn off the basic tooltip you can add additional measures to what would be shown or in my case you can say "don't even show the basic rows I will give you everything I want you to show"

And the result is:

[shayd]

I see,
Any chance that your suggestion is available only in the 2021 Qlik edition?
I'm using June 2019...

[Dalton_Ruer]

 It is newer than June 2019. 

[shayd]

Yep, that's my problem.
Thank you for your help.