topic Re: Bar Chart Color by Expression in App Development

Bar Chart Color by Expression

shayd — Tue, 21 Dec 2021 21:56:36 GMT

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!

Re: Bar Chart Color by Expression

Dalton_Ruer — Mon, 19 Apr 2021 20:29:15 GMT

Override the Tooltip with your own Custom Tooltip.

Re: Bar Chart Color by Expression

shayd — Tue, 20 Apr 2021 07:07:49 GMT

Could you explain furthermore please?

Re: Bar Chart Color by Expression

Dalton_Ruer — Tue, 20 Apr 2021 12:50:07 GMT

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:

Re: Bar Chart Color by Expression

shayd — Wed, 21 Apr 2021 06:53:19 GMT

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

Re: Bar Chart Color by Expression

Dalton_Ruer — Wed, 21 Apr 2021 12:27:01 GMT

It is newer than June 2019.

Re: Bar Chart Color by Expression

shayd — Wed, 21 Apr 2021 14:04:32 GMT

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