Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

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. 

Labels (4)
1 Solution

Accepted Solutions
ZoeM
Specialist
Specialist
Author

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

View solution in original post

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

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

Only({<Color=>})
ZoeM
Specialist
Specialist
Author

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