topic Set analysis with selection in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-with-selection/m-p/437308#M163091 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have expression</P><P></P><P><STRONG>Count({&lt;Var1={<STRONG>"=Var1 &gt;5"</STRONG>,"=Var1&lt;10"},QYYYY={'$(=QuarterName(max(QYYYY),-1))'}&gt;}TOTAL Variable2) </STRONG></P><P></P><P><STRONG>I need to Total count for previous Quarter and for Variable1 more than 5, but less than 10.</STRONG></P><P>If I select only Var1&gt;5, it works. If I select Var1&lt;10, it works. But together, NOOOOO<STRONG><BR /></STRONG></P><P>Var1 looks </P><TABLE border="0" cellpadding="0" cellspacing="0" width="138"><TBODY><TR><TD align="right" class="xl63" height="17" width="138">0</TD></TR><TR><TD align="right" class="xl63" height="17">0.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">0.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">1</TD></TR><TR><TD align="right" class="xl63" height="17">1.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">1.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">2</TD></TR><TR><TD align="right" class="xl63" height="17">2.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">2.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">3</TD></TR><TR><TD align="right" class="xl63" height="17">3.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">3.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">4</TD></TR><TR><TD align="right" class="xl63" height="17">4.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">4.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">5</TD></TR><TR><TD align="right" class="xl63" height="17">5.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">5.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">6</TD></TR><TR><TD align="right" class="xl63" height="17">6.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">6.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">7</TD></TR><TR><TD align="right" class="xl63" height="17">7.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">7.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">8</TD></TR><TR><TD align="right" class="xl63" height="17">8.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">8.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">9</TD></TR><TR><TD align="right" class="xl63" height="17">9.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">9.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">10</TD></TR></TBODY></TABLE><P></P><P><STRONG>Thanks,<BR /></STRONG></P></BODY></HTML> Wed, 13 Mar 2013 15:10:17 GMT Anonymous 2013-03-13T15:10:17Z Set analysis with selection https://community.qlik.com/t5/QlikView/Set-analysis-with-selection/m-p/437308#M163091 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have expression</P><P></P><P><STRONG>Count({&lt;Var1={<STRONG>"=Var1 &gt;5"</STRONG>,"=Var1&lt;10"},QYYYY={'$(=QuarterName(max(QYYYY),-1))'}&gt;}TOTAL Variable2) </STRONG></P><P></P><P><STRONG>I need to Total count for previous Quarter and for Variable1 more than 5, but less than 10.</STRONG></P><P>If I select only Var1&gt;5, it works. If I select Var1&lt;10, it works. But together, NOOOOO<STRONG><BR /></STRONG></P><P>Var1 looks </P><TABLE border="0" cellpadding="0" cellspacing="0" width="138"><TBODY><TR><TD align="right" class="xl63" height="17" width="138">0</TD></TR><TR><TD align="right" class="xl63" height="17">0.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">0.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">1</TD></TR><TR><TD align="right" class="xl63" height="17">1.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">1.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">2</TD></TR><TR><TD align="right" class="xl63" height="17">2.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">2.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">3</TD></TR><TR><TD align="right" class="xl63" height="17">3.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">3.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">4</TD></TR><TR><TD align="right" class="xl63" height="17">4.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">4.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">5</TD></TR><TR><TD align="right" class="xl63" height="17">5.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">5.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">6</TD></TR><TR><TD align="right" class="xl63" height="17">6.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">6.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">7</TD></TR><TR><TD align="right" class="xl63" height="17">7.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">7.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">8</TD></TR><TR><TD align="right" class="xl63" height="17">8.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">8.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">9</TD></TR><TR><TD align="right" class="xl63" height="17">9.333333333</TD></TR><TR><TD align="right" class="xl63" height="17">9.666666667</TD></TR><TR><TD align="right" class="xl63" height="17">10</TD></TR></TBODY></TABLE><P></P><P><STRONG>Thanks,<BR /></STRONG></P></BODY></HTML> Wed, 13 Mar 2013 15:10:17 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-selection/m-p/437308#M163091 Anonymous 2013-03-13T15:10:17Z Re: Set analysis with selection https://community.qlik.com/t5/QlikView/Set-analysis-with-selection/m-p/437309#M163092 <HTML><HEAD></HEAD><BODY><P>Do you have idea?</P></BODY></HTML> Wed, 13 Mar 2013 18:34:17 GMT https://community.qlik.com/t5/QlikView/Set-analysis-with-selection/m-p/437309#M163092 Anonymous 2013-03-13T18:34:17Z