topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/546590#M204169 <HTML><HEAD></HEAD><BODY><P>count({&lt;A={'A1'},B={'B2'},C={'C1'},D={'D1'}&gt;}A)</P><P></P><P>This will return 0 for your sample data since there is no record that fulfills all the conditions.</P><P></P><P>Unless you mean that only one of the conditions needs to be met, i.e. A=A1 or B=B2 ..etc. In that case use</P><P></P><P>count({&lt;A={'A1'}&gt;+&lt;B={'B2'}&gt;+&lt;C={'C1'}&gt;+&lt;D={'D1'}&gt;}A)</P></BODY></HTML> Sat, 06 Jul 2013 14:23:28 GMT Gysbert_Wassenaar 2013-07-06T14:23:28Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/546589#M204168 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have attached the excel file.....in that i need to find the Count of the field values based on the condition (i.e,A=A1,B=B2,C=C1,D=D1 then count of A,B,C,D) using Set Analysis............</P><P></P><P>Thanks in advance</P><P>smiley</P></BODY></HTML> Sat, 06 Jul 2013 14:06:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/546589#M204168 rathnam_qv 2013-07-06T14:06:38Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/546590#M204169 <HTML><HEAD></HEAD><BODY><P>count({&lt;A={'A1'},B={'B2'},C={'C1'},D={'D1'}&gt;}A)</P><P></P><P>This will return 0 for your sample data since there is no record that fulfills all the conditions.</P><P></P><P>Unless you mean that only one of the conditions needs to be met, i.e. A=A1 or B=B2 ..etc. In that case use</P><P></P><P>count({&lt;A={'A1'}&gt;+&lt;B={'B2'}&gt;+&lt;C={'C1'}&gt;+&lt;D={'D1'}&gt;}A)</P></BODY></HTML> Sat, 06 Jul 2013 14:23:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/546590#M204169 Gysbert_Wassenaar 2013-07-06T14:23:28Z