topic Re: Excluding a selection from a Pivot table in QlikView

Excluding a selection from a Pivot table

Mon, 28 Jan 2013 13:48:28 GMT

I have a pivot with a list of clients and stats beside them.

I want to permanently exclude a group of people (Tier A) from the pivot without having to make selections in the Tier list box.

What is the best way to go about this?

Client Tier $

Client A Tier A xx

Client B Tier A xx

Client C Tier B xx

Client D Tier B xx

Client E Tier C xx

Re: Excluding a selection from a Pivot table

Gysbert_Wassenaar — Mon, 28 Jan 2013 13:54:41 GMT

Replace the dimension Tier with a calculated dimension if(Tier<>'Tier A', Tier) and check the option Suppress When Value Is Null for the calculated dimension.

Re: Excluding a selection from a Pivot table

Mon, 28 Jan 2013 14:50:36 GMT

Doesn't seem to work- they are still showing up.

Any other ideas?

Re: Excluding a selection from a Pivot table

SunilChauhan — Mon, 28 Jan 2013 14:57:33 GMT

see the attached file

hope this helps