Highlighting Bar Chart based on Current Selections

[Anonymous]

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?

[#2]

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