Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ZoeM
Contributor II

Chart bars changing color when clicked on

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.Chart 1.JPG

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

Chart.JPG

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

Thanks in advance team. 

1 Solution

Accepted Solutions
Highlighted
ZoeM
Contributor II

Re: Chart bars changing color when clicked on

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...

2 Replies
sergio0592
Valued Contributor II

Re: Chart bars changing color when clicked on

Hi,

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

Only({<Color=>})
Highlighted
ZoeM
Contributor II

Re: Chart bars changing color when clicked on

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...