Dynamic filtering in a chart

Mon, 22 Aug 2011 09:31:42 GMT

Hello all,

i am struggling for two days now to implement a useful feature in one of our client's dashboard, and i can’t get around it (yet). I thought maybe you have an idea on how this can be done.

Let's say we have a chart with year on X axis and Countries on the Y axis.

In the expression, we count the number of people in each country per year, and we are analyzing the ups and downs of the population within each country.

Now, because there are so many countries, i want to filter out some of them, and to see only the countries which had a growing population for a selected period (in years).

I have created a VBScript that gives me the min (minYear) and max (maxYear) selected years in the Year list box.

And I sum up the population by doing a count(People) in the chart expression.

Also i created two buttons (+ and - ) that set up a variable (varPol) that is either Positive or Negative, to choose the filtering (growth or decrease)

How can i show only the countries which had a growth/decrease in population for the period of minYear - maxYear ?

Screenshot:

the + button would let visible only the blue line, the minus button would show only the red line.

Cheers,

John

Re: Dynamic filtering in a chart

lironbaram — Mon, 22 Aug 2011 10:43:53 GMT

hei

attach is an example

i think it what you are after

hope its helps you

Re: Dynamic filtering in a chart

Mon, 22 Aug 2011 12:15:18 GMT

Yep, it does what i wanted, thanks!

topic Re: Dynamic filtering in a chart in QlikView

Dynamic filtering in a chart

Re: Dynamic filtering in a chart

Re: Dynamic filtering in a chart