topic Exclude Entire Dimension Based on Single Value in Another Dimension with Set Analysis in QlikView

Exclude Entire Dimension Based on Single Value in Another Dimension with Set Analysis

mpressey — Wed, 25 Nov 2020 16:16:04 GMT

Is there a way using set analysis to exclude the entire Dim 'a' based on the Dim2 value of '1'. This is an simplified example.

Re: Exclude Entire Dimension Based on Single Value in Another Dimension with Set Analysis

Vegar — Wed, 20 Mar 2019 22:23:19 GMT

Try this expression

Count({<Dim = e({<Dim2 = {'1'}>}) >}Dim)

Re: Exclude Entire Dimension Based on Single Value in Another Dimension with Set Analysis

mpressey — Wed, 20 Mar 2019 23:48:38 GMT

Thanks. This of course works in the simplified example and is essentially what I initially started with in my actual application. Finally, I realized that I was applying the exclusion to the wrong dimension. Thanks again for the reply. It helped me stay on the right track.