Filtering data in a pivot table

Fri, 15 Jan 2010 21:38:56 GMT

Hi Team - I have a pivot table with three dimensions and two calculated fields. I would like to filter out the records where Order Count <5. Since this is a pivot Chart, so the filtering should be dynamic.

Any help would be appreciated - Thanks

Customer Name	Ship ID	Warehouse ID	Case Count	Order Count
ALBERTSONS, INC.	30106	101	2,152	8
ALBERTSONS, INC.	30121	101	3,594	6
ALBERTSONS, INC.	30121	487	850	2
ALBERTSONS, INC.	30130	101	20,676	46
ALBERTSONS, INC.	30258	101	8,550	5
ALDI/BATAVIA #440	18136	101	6,400	4
ALDI/BATAVIA #440	18136	453	0	1
ALDI/BATAVIA #440	18136	484	113,089	72
ALDI/BATAVIA #440	30043	101	1,600	1
ALDI/BATAVIA #440	30043	453	1,510	1
ALDI/BATAVIA #440	30043	484	68,686	43
ALDI/BATAVIA #440	30062	484	408	1
ALDI/BATAVIA #440	30064	453	9,856	4
ALDI/BATAVIA #440	44833	101	4,800	3
ALDI/BATAVIA #440	44833	456	408	1
ALDI/BATAVIA #440	44833	484	408	1
ALDI/BATAVIA #440	48513	101	1,600	1
ALDI/BATAVIA #440	48513	456	20,497	14
ALDI/BATAVIA #440	48513	484	42,812	27
ALDI/BATAVIA #440	48980	453	30,912	17
ALDI/BATAVIA #440	49883	453	12,784	9
ALDI/BATAVIA #440	49883	484	1,602	1
ALDI/BATAVIA #440	50603	456	1,600	1

Filtering data in a pivot table

johnw — Fri, 15 Jan 2010 21:50:07 GMT

If your expressions are this:

count(Case)
count(Order)

Then I'd probably do this:

if(count(Order)>=5,count(Case))
if(count(Order)>=5,count(Order))

But that filtering doesn't seem very dynamic. What do you MEAN by dynamic filtering? That the user can set the lower limit for display? For that, I'd user a slider for a variable, and do the same expression but with a variable replacing the 5.

Another approach to dynamic filtering that I think would work would be a list box with this expression:

aggr(sum(Count),"Customer Name","Ship ID","Warehouse ID")

That would give you a list if the order counts, and you could select the counts you wanted to see.

If none of that is what you meant, can you clarify?

topic Filtering data in a pivot table in QlikView

Filtering data in a pivot table

Filtering data in a pivot table