How to Filter on Aggregated/Summed Data?

Sat, 23 Mar 2013 15:23:01 GMT

Hello -

Say I have the following data in QV:

Sales	Year	Country
90,000	2009	Country A
40,000	2009	Country B
100,000	2009	Country C
60,000	2010	Country A
40,000	2010	Country B
90,000	2010	Country C
30,000	2011	Country A
80,000	2011	Country B
10,000	2011	Country C
50,000	2012	Country A
70,000	2012	Country B
10,000	2012	Country C

I created a chart/table that shows sales value by year (aggregated by country). I would like to create a slider/filter that allows me to chose parameters based on total sales, not individual. For example, the 2009 total sales from above is 230,000 (90,000 + 40,000 + 100,000). I would like to have the ability to choose a filter value between 150,000 to 300,000 and have the 2009 total display. When I add a slider however, the max value that shows up on the slider is 100,000 (since that's the max sales line item in the data set above). How would I create a slider that would allow the user to filter values based on aggregated yearly sales? (example attached)

Re: How to Filter on Aggregated/Summed Data?

sushil353 — Sat, 23 Mar 2013 15:43:52 GMT

Try this:

In slider instead of selecting field select Expression and put

=Aggr(sum(Sales),Year)

HTH

Sushil

Re: How to Filter on Aggregated/Summed Data?

Sat, 23 Mar 2013 15:50:43 GMT

Hi,

take a look a the attached app. May be it helps.

Regards

Roland

topic How to Filter on Aggregated/Summed Data? in QlikView

How to Filter on Aggregated/Summed Data?

Re: How to Filter on Aggregated/Summed Data?

Re: How to Filter on Aggregated/Summed Data?