Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

colour of pie chart selection determines the colour of the table

Is there a way that on selection of a slice of a pie chart, depending on the colour of the slice of the pie, that that colour will change the active caption of a table?

I'm assuming i need to capture the RGB of the slice and put it into the Active caption background colour as a calculated expression but if there are 6 different colour slices that have different RGB colours?

Help appreciated.

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III

Your Expression Background color should be as below

if(Spend='Regulator', rgb(0,217,0))

your Chart Active Caption background Color should be as below

if(Spend = 'Regulator', rgb(0,217,0))

Add all your six combinations in else part

View solution in original post

5 Replies
avinashelite

we don't have way how your excepting but try like this use the expression to set the slice color of the dimension values and then based on the dimension selection set the header color

Hope you got the answer

krishnacbe
Partner - Specialist III
Partner - Specialist III

Yes you are right, only you should use RGB colors in Pie Chart Expression and Other chart Active caption.

But one challenge will be if user selects multiple values in the Pie.

bobbydave
Creator III
Creator III
Author

Capture.JPG

This is an example of what i am trying to achieve. You see the green portion will open a green active caption in the table and relevant data is associated with this green colour.

There wont be multiple selections as the table shows information relevant to the colour.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Your Expression Background color should be as below

if(Spend='Regulator', rgb(0,217,0))

your Chart Active Caption background Color should be as below

if(Spend = 'Regulator', rgb(0,217,0))

Add all your six combinations in else part

bobbydave
Creator III
Creator III
Author

Yeah, i actually used simple 'if' statements in the end and it worked.

I think i may have been over complicating it.

But yeah, 'if' statements did it.