topic Need an intersect with setanalysis in QlikView https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399311#M1162841 <HTML><HEAD></HEAD><BODY><P>I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)</P><P></P><P>I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)</P><P></P><P>=if ((Mat/Inns)=max(Mat/Inns), Player)</P><P></P><P>Please help.</P><P></P><P>Thanks</P><P>Ram</P></BODY></HTML> Wed, 10 Oct 2012 13:13:27 GMT 2012-10-10T13:13:27Z Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399311#M1162841 <HTML><HEAD></HEAD><BODY><P>I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)</P><P></P><P>I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)</P><P></P><P>=if ((Mat/Inns)=max(Mat/Inns), Player)</P><P></P><P>Please help.</P><P></P><P>Thanks</P><P>Ram</P></BODY></HTML> Wed, 10 Oct 2012 13:13:27 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399311#M1162841 2012-10-10T13:13:27Z Re: Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399312#M1162842 <HTML><HEAD></HEAD><BODY><P>Use <SPAN style="font-size: 8pt;">= </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">rank</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #800000; font-size: 8pt;">Mat</SPAN><SPAN style="font-size: 8pt;">/</SPAN><SPAN style="color: #800000; font-size: 8pt;">Inn</SPAN><SPAN style="font-size: 8pt;">))&lt;=10,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Player</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Player</SPAN><SPAN style="font-size: 8pt;">) instead and see the attached QV application</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">Mhatim</SPAN></P></BODY></HTML> Wed, 10 Oct 2012 13:30:59 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399312#M1162842 2012-10-10T13:30:59Z Re: Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399313#M1162843 <HTML><HEAD></HEAD><BODY><P>Thanks Mhatim. It did the trick when it came to chart. But I am trying to achieve this in a list box through an expression.</P></BODY></HTML> Wed, 10 Oct 2012 13:54:07 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399313#M1162843 2012-10-10T13:54:07Z Re: Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399314#M1162844 <HTML><HEAD></HEAD><BODY><P>See attached file</P></BODY></HTML> Wed, 10 Oct 2012 14:38:41 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399314#M1162844 Gysbert_Wassenaar 2012-10-10T14:38:41Z Re: Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399315#M1162845 <HTML><HEAD></HEAD><BODY><P>In the list box under the Field use the same expression</P><P>Please see the attached QV application.</P><P></P><P>regards</P><P>Mhatim</P></BODY></HTML> Wed, 10 Oct 2012 14:38:56 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399315#M1162845 2012-10-10T14:38:56Z Re: Need an intersect with setanalysis https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399316#M1162846 <HTML><HEAD></HEAD><BODY><P>Thanks Mhatim and gwassenaar</P></BODY></HTML> Thu, 11 Oct 2012 03:02:14 GMT https://community.qlik.com/t5/QlikView/Need-an-intersect-with-setanalysis/m-p/399316#M1162846 2012-10-11T03:02:14Z