topic Re: Help with set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398082#M1157335 <HTML><HEAD></HEAD><BODY><P>can you add me a qvw sample?</P><P>regards,</P></BODY></HTML> Mon, 04 Feb 2013 09:52:04 GMT fdelacal 2013-02-04T09:52:04Z Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398079#M1157332 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I've to calculate how many customers have sales order value &lt;&gt; 0 in percentage , matching this value with the total customer number</P><P></P><P>Total customers:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000</P><P>Total customers with sales order amount:&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PErc.&nbsp; 20%</P><P></P><P>I've prepared one table where I joined customers and orders and I'm trying without success the following:</P><P></P><P><STRONG>count({&lt;{"=Sum(OrderValue) &lt;&gt; 0"}&gt;} distinct Customer )</STRONG></P><P></P><P></P><P>but it doesn't work</P><P></P><P>What can I do ? Help please !!</P><P></P><P>Thanks in advance</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Mon, 04 Feb 2013 09:31:15 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398079#M1157332 Anonymous 2013-02-04T09:31:15Z Re: Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398080#M1157333 <HTML><HEAD></HEAD><BODY><P>Trie with this.</P><P>hope it helps you.</P><P></P><P>regards. </P><P></P><P>=num(</P><P>count( {$&lt;<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">OrderValue</STRONG> &lt;&gt; {'0'}&gt;} <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">Customer </STRONG>) /</P><P>count( {$&lt;<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">OrderValue</STRONG> = &gt;} <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">Customer </STRONG>),'#,00%')</P></BODY></HTML> Mon, 04 Feb 2013 09:35:08 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398080#M1157333 fdelacal 2013-02-04T09:35:08Z Re: Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398081#M1157334 <HTML><HEAD></HEAD><BODY><P>I'm sorry but it doesn't work</P><P>Thanks </P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Mon, 04 Feb 2013 09:48:15 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398081#M1157334 Anonymous 2013-02-04T09:48:15Z Re: Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398082#M1157335 <HTML><HEAD></HEAD><BODY><P>can you add me a qvw sample?</P><P>regards,</P></BODY></HTML> Mon, 04 Feb 2013 09:52:04 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398082#M1157335 fdelacal 2013-02-04T09:52:04Z Re: Help with set analysis https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398083#M1157336 <HTML><HEAD></HEAD><BODY><P>Unfortunatly I can't</P></BODY></HTML> Mon, 04 Feb 2013 09:59:06 GMT https://community.qlik.com/t5/QlikView/Help-with-set-analysis/m-p/398083#M1157336 Anonymous 2013-02-04T09:59:06Z