topic Highlighting Bar Chart based on Current Selections in QlikView

Highlighting Bar Chart based on Current Selections

Anonymous — Wed, 07 Oct 2015 07:09:41 GMT

This video has a detailed explanation on How to highlight Bar Chart based on Current selection

Highlight QlikView Bar Chart based on Current Selections - YouTube

This simple logic, if given in Expression -> Background Color gets that done.

If

(

GetSelectedCount(Procuct)>=1,

If

(

Match(Vertical, $(=vBarHighlight)) = 1, Green(),blue()

), blue()

)

It works perfectly when there is a single dimension. Say, I have a dimension Year which has values 2012,2013. Both the bars should be highlighted in different colors. The above solution works only for single dimension.

Any idea on how to do this for multiple dimension?

Re: Highlighting Bar Chart based on Current Selections

Wed, 07 Oct 2015 07:28:26 GMT

Hi Koushik,

Same Condition with a small add on

If

(

GetSelectedCount(Procuct)>=1 or (Second dimension condition),

If

(

Match(Vertical, $(=vBarHighlight)) = 1, Green(),blue()

), blue()

)

Hope You Will get