topic How to do in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/How-to-do-in-Set-Analysis/m-p/216334#M69670 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have set of questions answered by customers. Please check the attachment file.<BR />I am displaying the Customer Questionwise Dissatisfaction Trend with a bar chart using QNo as Dimension and expression as =Count({&lt;AnsID={2}&gt;}Customer)</P><P>Consider QNo.6[Do you have any other feedback?],<BR />if customer says 'Yes' means he is not satisfied for that perticular question and should come in Dissatisfaction Trend with expression =Count({&lt;AnsID={1}&gt;}Customer)<BR />How can I show both combination of expressions in one expression? which gives count of customers for Q1,2,3,4,5,7 where AnsID=2 and for Q6 where AnsID=2<BR /><BR />Output should be<BR />0 0 1 1 0 2 1<BR />Q1 Q2 Q3 Q4 Q5 Q6 Q7</P><P>Thanks,</P></BODY></HTML> Wed, 08 Dec 2010 05:24:40 GMT 2010-12-08T05:24:40Z How to do in Set Analysis https://community.qlik.com/t5/QlikView/How-to-do-in-Set-Analysis/m-p/216334#M69670 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have set of questions answered by customers. Please check the attachment file.<BR />I am displaying the Customer Questionwise Dissatisfaction Trend with a bar chart using QNo as Dimension and expression as =Count({&lt;AnsID={2}&gt;}Customer)</P><P>Consider QNo.6[Do you have any other feedback?],<BR />if customer says 'Yes' means he is not satisfied for that perticular question and should come in Dissatisfaction Trend with expression =Count({&lt;AnsID={1}&gt;}Customer)<BR />How can I show both combination of expressions in one expression? which gives count of customers for Q1,2,3,4,5,7 where AnsID=2 and for Q6 where AnsID=2<BR /><BR />Output should be<BR />0 0 1 1 0 2 1<BR />Q1 Q2 Q3 Q4 Q5 Q6 Q7</P><P>Thanks,</P></BODY></HTML> Wed, 08 Dec 2010 05:24:40 GMT https://community.qlik.com/t5/QlikView/How-to-do-in-Set-Analysis/m-p/216334#M69670 2010-12-08T05:24:40Z