Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mpressey
Creator
Creator

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

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. 

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this expression

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

image.png

View solution in original post

2 Replies
Vegar
MVP
MVP

Try this expression

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

image.png

mpressey
Creator
Creator
Author

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.