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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How To Filter A Set Based On Multiple Values?

Hello,

A quick question.  I am not sure how to apply a set of values within the set analysis.  Below is my expression.  I would like to filter RepeatBucket by values greater than 5.  Is that possible without listing all possible values, and apply a condition?

sum({<Yr={2011},REPEATBUCKET={6,7... etc} >}COUNT)

Sincerely.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi,

try

=sum({<Yr={2011},REPEATBUCKET={">5"} >}COUNT)

Regards,

Stefan

View solution in original post

1 Reply
swuehl
MVP
MVP

Hi,

try

=sum({<Yr={2011},REPEATBUCKET={">5"} >}COUNT)

Regards,

Stefan