Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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