topic Re: Re: Filtering data in a pivot table in QlikView

Filtering data in a pivot table

Tue, 29 Oct 2013 19:45:20 GMT

Hi Team - I have a pivot table with three dimensions and two calculated fields. I would like to filter out the records where Inventory Sum between 20 to 50. Since this is a pivot Chart, so the filtering should be dynamic.is there possible use slider with 2 Variables?

Any help would be appreciated - Thanks

Header 1

Header 2

Article

Inventory

00091952
00098964
00099916
00099916
00099917
00099919
00099994
00099994
00099994
13102883
13191810
13191848
13191848
13194745

13
3
5
55
2
2
100
40
10
1
20
200
1
30

Re: Filtering data in a pivot table

Gysbert_Wassenaar — Wed, 30 Oct 2013 18:24:10 GMT

Please post an example document that includes a set of data that includes the other fields too.

Preparing examples for Upload - Reduction and Data Scrambling

Re: Re: Filtering data in a pivot table

Wed, 30 Oct 2013 20:35:17 GMT

Thanks a lot

Re: Filtering data in a pivot table

rustyfishbones — Wed, 30 Oct 2013 22:28:28 GMT

Try this using SALES_INVENTORY_VIEW.NUM_SALE as your measure

Re: Filtering data in a pivot table

Thu, 31 Oct 2013 06:55:39 GMT

Thanks Alan

How can i use a dynamic range in filtering? ( Slider and 2 variables)

Re: Re: Re: Filtering data in a pivot table

Gysbert_Wassenaar — Thu, 31 Oct 2013 09:00:36 GMT

See attached qvw

Re: Filtering data in a pivot table

rustyfishbones — Thu, 31 Oct 2013 09:07:36 GMT

Fantastic solution G Wassenar

Re: Filtering data in a pivot table

rustyfishbones — Thu, 31 Oct 2013 09:38:17 GMT

See G Wassenar solution below

Re: Filtering data in a pivot table

Thu, 31 Oct 2013 10:34:24 GMT

Excellent Dears : G Wassender and Alan Farrell