topic How To Filter A Set Based On Multiple Values? in QlikView https://community.qlik.com/t5/QlikView/How-To-Filter-A-Set-Based-On-Multiple-Values/m-p/286277#M106508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try</P><P></P><P>=sum({&lt;Yr={2011},REPEATBUCKET={"&gt;5"} &gt;}COUNT)</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Fri, 23 Sep 2011 17:31:51 GMT swuehl 2011-09-23T17:31:51Z How To Filter A Set Based On Multiple Values? https://community.qlik.com/t5/QlikView/How-To-Filter-A-Set-Based-On-Multiple-Values/m-p/286276#M106507 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana,geneva;">Hello,</SPAN></P><P><SPAN style="font-family: verdana,geneva;">A quick question.&nbsp; I am not sure how to apply a set of values within the set analysis.&nbsp; Below is my expression.&nbsp; I would like to filter RepeatBucket by values greater than 5.&nbsp; Is that possible without listing all possible values, and apply a condition?</SPAN></P><P><SPAN style="font-family: verdana,geneva;"> </SPAN></P><P><SPAN style="font-family: verdana,geneva;"><SPAN style="color: blue; font-size: 9pt;">sum</SPAN><SPAN style="color: black; font-size: 9pt;">({&lt;</SPAN><SPAN style="color: maroon; font-size: 9pt;">Yr</SPAN><SPAN style="color: black; font-size: 9pt;">={2011},</SPAN><SPAN style="color: maroon; font-size: 9pt;">REPEATBUCKET</SPAN><SPAN style="color: black; font-size: 9pt;">={6,7... etc} &gt;}</SPAN><SPAN style="color: maroon; font-size: 9pt;">COUNT</SPAN><SPAN style="color: black; font-size: 9pt;">)</SPAN></SPAN></P><P></P><P><SPAN style="font-family: verdana,geneva;">Sincerely.</SPAN></P></BODY></HTML> Fri, 23 Sep 2011 17:26:55 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-A-Set-Based-On-Multiple-Values/m-p/286276#M106507 2011-09-23T17:26:55Z How To Filter A Set Based On Multiple Values? https://community.qlik.com/t5/QlikView/How-To-Filter-A-Set-Based-On-Multiple-Values/m-p/286277#M106508 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try</P><P></P><P>=sum({&lt;Yr={2011},REPEATBUCKET={"&gt;5"} &gt;}COUNT)</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Fri, 23 Sep 2011 17:31:51 GMT https://community.qlik.com/t5/QlikView/How-To-Filter-A-Set-Based-On-Multiple-Values/m-p/286277#M106508 swuehl 2011-09-23T17:31:51Z