topic Re: Re: Conditionally suppress pivot table rows in QlikView

Conditionally suppress pivot table rows

Mon, 28 Jul 2014 05:48:59 GMT

Hi,

I have a pivot table like so:

Dim1 values = category1, category2, category3

Dim2 values = LA, NY, SF

There are two expressions = exp1 and exp2

Dim1 category1 category2 category3

Dim2 exp1 exp2 exp1 exp2 exp1 exp2

LA 5 6 12 9 10 1

NY 12 11 7 8 2 1

SF 5 1 2 11 7 3

What I need to do is to hide those rows whose exp2 value is less than 2 for the last element of Dim1 (category3 in this example). So here, I would want to hide rows for LA and NY, but not for SF. Please note that SF has its exp2 less than 2 for category1, so it should display.

Re: Conditionally suppress pivot table rows

Mon, 28 Jul 2014 06:15:13 GMT

Please attach example

Re: Re: Conditionally suppress pivot table rows

Mon, 28 Jul 2014 07:43:05 GMT

Here is a sample qvw. here again, SF should display and the other two rows hidden since their cat3 value for the Score expression is less than 2.

Re: Re: Conditionally suppress pivot table rows

Mon, 28 Jul 2014 07:53:00 GMT

not possible. Use Straight table and try