topic Re: Filtering the top 5 sales from a pivot table in QlikView

Filtering the top 5 sales from a pivot table

cafcptg2011 — Thu, 25 Oct 2012 10:19:02 GMT

Hi,

I need to filter the customers (from a top 5 sales pivot table) that has sales in 2011 and 2012 (and exclude the others customers). To understand better i show you a picture with my problem. Also, i attached qvw with pivot table.

Can anyone one help me please?

Thanks in advance,

Cafc

Re: Filtering the top 5 sales from a pivot table

Gysbert_Wassenaar — Thu, 25 Oct 2012 10:40:46 GMT

Try:

= if(aggr(rank(SUM (sales ),0),id)<=5

and aggr(sum({$<y={'2011'}>} sales),id) > 0

and aggr(sum({$<y={'2012'}>} sales),id) > 0, id)

Re: Filtering the top 5 sales from a pivot table

cafcptg2011 — Thu, 25 Oct 2012 10:43:46 GMT

Hi, it works!!

Thank you very much!