topic count with multiple conditions based on list box in QlikView https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340281#M821739 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="191" style="border: 1px solid #000000; width: 339px; height: 185px;" width="336"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>App</STRONG></TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>Group1</STRONG></TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>Group2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">0001</TD><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">0002</TD><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">0003</TD><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">0004</TD><TD style="padding: 2px; text-align: center;">C</TD><TD style="padding: 2px; text-align: center;">C</TD></TR><TR><TD style="padding: 2px; text-align: center;">0005</TD><TD style="padding: 2px; text-align: center;"></TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">0006</TD><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">...</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">...</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="119" style="border: 1px solid rgb(0, 0, 0); width: 72px; height: 99px;"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>List Box (Group2)</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">C</TD></TR></TBODY></TABLE><P></P><P></P><P>Hi masters! I am trying to create a count if with multiple conditions having one of those conditions based on the selected field of the list box.</P><P></P><P>The conditions should be as following:</P><P>vSelectedField = GetFieldSelections(Group2,',')</P><P></P><P>Group1 &lt;&gt; ''&nbsp;&nbsp;&nbsp; (not blank)</P><P>Group1 = Group2</P><P>Group1 = $(=vSelectedField)</P><P></P><P></P><P>something like this:</P><P>=count({1&lt;Group1 -= {''}, Group1 = p(Group2), Group1=$(=vSelectedField)}&gt;}App)</P><P></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT felipe_oliveira 2020-11-25T16:16:04Z count with multiple conditions based on list box https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340281#M821739 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="191" style="border: 1px solid #000000; width: 339px; height: 185px;" width="336"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>App</STRONG></TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>Group1</STRONG></TH><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>Group2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">0001</TD><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">0002</TD><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">0003</TD><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">0004</TD><TD style="padding: 2px; text-align: center;">C</TD><TD style="padding: 2px; text-align: center;">C</TD></TR><TR><TD style="padding: 2px; text-align: center;">0005</TD><TD style="padding: 2px; text-align: center;"></TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">0006</TD><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">...</TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">...</SPAN></TD><TD style="padding: 2px; text-align: center;"><SPAN style="font-size: 13.3333px; text-align: center;">...</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="1" class="jiveBorder" height="119" style="border: 1px solid rgb(0, 0, 0); width: 72px; height: 99px;"><TBODY><TR><TH style="text-align:center;background-color:#6690BC;color:#ffffff;padding:2px;" valign="middle"><STRONG>List Box (Group2)</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD></TR><TR><TD style="padding: 2px; text-align: center;">C</TD></TR></TBODY></TABLE><P></P><P></P><P>Hi masters! I am trying to create a count if with multiple conditions having one of those conditions based on the selected field of the list box.</P><P></P><P>The conditions should be as following:</P><P>vSelectedField = GetFieldSelections(Group2,',')</P><P></P><P>Group1 &lt;&gt; ''&nbsp;&nbsp;&nbsp; (not blank)</P><P>Group1 = Group2</P><P>Group1 = $(=vSelectedField)</P><P></P><P></P><P>something like this:</P><P>=count({1&lt;Group1 -= {''}, Group1 = p(Group2), Group1=$(=vSelectedField)}&gt;}App)</P><P></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340281#M821739 felipe_oliveira 2020-11-25T16:16:04Z Re: count with multiple conditions based on list box https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340282#M821740 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;App = {"=Len(Trim(Group)) &gt; 0 and Group1 = Group2"}&gt;}App)</STRONG></P></BODY></HTML> Wed, 02 Aug 2017 18:29:19 GMT https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340282#M821740 sunny_talwar 2017-08-02T18:29:19Z Re: count with multiple conditions based on list box https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340283#M821741 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Thu, 03 Aug 2017 16:16:43 GMT https://community.qlik.com/t5/QlikView/count-with-multiple-conditions-based-on-list-box/m-p/1340283#M821741 felipe_oliveira 2017-08-03T16:16:43Z