topic How to highlight data from a chart without clearing / hiding the rest of the values? in QlikView

How to highlight data from a chart without clearing / hiding the rest of the values?

Gaurav2203 — Tue, 19 Nov 2019 12:56:48 GMT

Hi,

I am developing a bar chart with month as a dimension. And I want to do is that when I select a particular month or n months, I want the data of those selected month to be highlighted without losing the rest of the data i.e. gray out the unselected months and highlight the selected month just like we do in List box.

Is there a way this could be achieved??

Re: How to highlight data from a chart without clearing / hiding the rest of the values?

Lisa_P — Tue, 19 Nov 2019 22:32:41 GMT

Use this as a Background Color expression by expanding your measure expression.

if(Month=Month,LightBlue(),LightGray())

Re: How to highlight data from a chart without clearing / hiding the rest of the values?

Brett_Bleess — Wed, 04 Dec 2019 15:43:04 GMT

Gaurav, did Lisa's post work as a solution for you? If so, please be sure to return to the thread and use the Accept as Solution button on her post to give her credit for the assistance and to let other Community Members know it did work for you. If you are still working on things, let us know where you are and what you still need to see if someone can come up with something further.

Regards,
Brett