topic Re: Chart bars changing color when clicked on in QlikView

Chart bars changing color when clicked on

ZoeM — Sat, 16 Nov 2024 03:51:10 GMT

Hello Community.

I have a unique one today. I have a combo chart where I have buttons that activate/deactivate the expressions (Legend titles) accordingly.

When I click on any one of the expression buttons, the bars color change and I would like for them to remain consistent. I have persistent colors under the colors tab and I am also using an expression in the 'plus' expansion within the expression to hide data that is not pertinent to the illustration (aka future months from current month).

Any ides on how I can maintain the color scheme even as the buttons are clicked?

Thanks in advance team.

Re: Chart bars changing color when clicked on

sergio0592 — Tue, 16 Apr 2019 12:19:21 GMT

Hi,

If you use a table color with Color field, youn can write as expression background color :

Only({<Color=>})

Re: Chart bars changing color when clicked on

ZoeM — Tue, 16 Apr 2019 19:56:40 GMT

Thanks for your reply Sergio.

I ended up using the Background color effect from the expression to resolve and it works fine. I modified the existing Set Analysis expression into a if statement.

=if(YearMonth>MonthStart(Today()),White(),RGB(77,167,65))

I then added a Condition for calculation:

=vGlidepath='Declared' or vGlidepath=''

Thanks...