QlikView's natural behavior is to zoom in on the data once a selection is made. However, there is a great downside to doing this: you lose some context because the rest of the elements disappear. One of the most popular ways to overcome this phenomenon is to mix color functions with our good old friend—Set Analysis.
Example: NBA standings.
Relevant features: Set Analysis and color highlight.
To create this visualization, you can do the following:
Team
as the dimension and sum(Wins)
as the expression.=if(match(Team, concat(DISTINCT Team, ',')),RGB(130, 170, 190), ARGB(45, 130, 170, 190))
This expression starts by creating a list of the possible teams (the white and green items in a list box) with a concat()
function:
concat(DISTINCT Team, ',') > Cavs, Bulls, Bucks, Pacers, Pistons
After that, there's a match()
statement evaluating whether each team is in that list or not. If the result is positive, it assigns the bright color. Otherwise, it assigns the transparent one.
sum({$<Conference=, Division=, Team=>} Wins)