topic Re: Cross Table Count and Average in QlikView https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679982#M246609 <HTML><HEAD></HEAD><BODY><P>Dear Harrison,</P><P></P><P>Please try the attached QVW for Solution:-</P><P></P><P>In Straight Table take Questions as Dimension and use three expressions:-</P><P></P><P>Yes:- <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'Yes'}&gt;}<SPAN style="color: #800000;">Answers</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P>No:-&nbsp; <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'No'}&gt;}<SPAN style="color: #800000;">Answers</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN><BR />Average:- <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'Yes'}&gt;}<SPAN style="color: #800000;">Answers</SPAN>)/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">[Shop Name]</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Thanks &amp; Regards</SPAN></P><P><SPAN style="font-size: 12pt;">Prince Anand</SPAN></P><P></P></BODY></HTML> Wed, 08 Oct 2014 11:03:43 GMT 2014-10-08T11:03:43Z Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679981#M246608 <HTML><HEAD></HEAD><BODY><P>Kindly assist.</P><P>Using the attached, I have loaded my Data as a Cross table but I can not proceed from there. I have loaded the attributes as Questions and the Data as Answers.</P><P></P><P>I want to determine the count of Yes' and Nos for every question and establish the average i.e. TotalCountYes/TotalCountShopName</P></BODY></HTML> Wed, 08 Oct 2014 10:30:27 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679981#M246608 chiso_chiso 2014-10-08T10:30:27Z Re: Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679982#M246609 <HTML><HEAD></HEAD><BODY><P>Dear Harrison,</P><P></P><P>Please try the attached QVW for Solution:-</P><P></P><P>In Straight Table take Questions as Dimension and use three expressions:-</P><P></P><P>Yes:- <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'Yes'}&gt;}<SPAN style="color: #800000;">Answers</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P>No:-&nbsp; <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'No'}&gt;}<SPAN style="color: #800000;">Answers</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN><BR />Average:- <SPAN style="color: #0000ff; font-size: 12pt;">count</SPAN><SPAN style="font-size: 12pt;">({$&lt;<SPAN style="color: #800000;">Answers</SPAN>={'Yes'}&gt;}<SPAN style="color: #800000;">Answers</SPAN>)/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #800000;">[Shop Name]</SPAN></SPAN><SPAN style="font-size: 12pt;">) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;">Thanks &amp; Regards</SPAN></P><P><SPAN style="font-size: 12pt;">Prince Anand</SPAN></P><P></P></BODY></HTML> Wed, 08 Oct 2014 11:03:43 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679982#M246609 2014-10-08T11:03:43Z Re: Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679983#M246610 <HTML><HEAD></HEAD><BODY><P>Thanks Prince,</P><P></P><P>How do I eliminate the blanks in my count?</P></BODY></HTML> Wed, 08 Oct 2014 11:18:18 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679983#M246610 chiso_chiso 2014-10-08T11:18:18Z Re: Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679984#M246611 <HTML><HEAD></HEAD><BODY><P>Dear Harrison,</P><P></P><P>By default It don't count Blans,So you not need to eliminate blanks.</P><P></P><P>Thanks &amp; Regards</P><P>Prince Anand</P></BODY></HTML> Wed, 08 Oct 2014 11:22:01 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679984#M246611 2014-10-08T11:22:01Z Re: Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679985#M246612 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Prince Anand</P></BODY></HTML> Wed, 08 Oct 2014 11:23:21 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679985#M246612 chiso_chiso 2014-10-08T11:23:21Z Re: Cross Table Count and Average https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679986#M246613 <HTML><HEAD></HEAD><BODY><P>Welcome Harrison<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 08 Oct 2014 11:31:02 GMT https://community.qlik.com/t5/QlikView/Cross-Table-Count-and-Average/m-p/679986#M246613 2014-10-08T11:31:02Z