topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135344#M914100 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(Max(TOTAL &lt;DEPT&gt; SAL, 2) &lt;= SAL, ENAME)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125608_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 24 May 2016 15:14:38 GMT sunny_talwar 2016-05-24T15:14:38Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135340#M914096 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; i&nbsp; have&nbsp; two tables&nbsp; like</P><P>table1:&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;&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; </P><P>EID ENAME&nbsp;&nbsp;&nbsp;&nbsp; </P><P>1&nbsp;&nbsp;&nbsp;&nbsp; mahesh</P><P>2 rajesh</P><P>3 uday</P><P>4 pavan </P><P>5 raghu</P><P>6 rafi</P><P></P><P>Table2:</P><P>EID&nbsp; DEPT&nbsp; SAL</P><P>1&nbsp;&nbsp; HR&nbsp;&nbsp;&nbsp; 10000</P><P>2 SE&nbsp;&nbsp; 25000</P><P>3 HR&nbsp;&nbsp; 60000</P><P>4 SE&nbsp; 30000</P><P>5 HR 12900</P><P>6 SE 23000</P><P></P><P>I want to display the&nbsp; top max&nbsp; two salaries from each department </P><P> how to write this in set Analysis</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135340#M914096 Anonymous 2020-11-25T16:16:04Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135341#M914097 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125603_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 24 May 2016 14:50:10 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135341#M914097 sunny_talwar 2016-05-24T14:50:10Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135342#M914098 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; sunny </P><P>Thanks for&nbsp; answer </P><P>But i was unable to open QVW file as&nbsp; I am&nbsp; desktop version ..</P></BODY></HTML> Tue, 24 May 2016 15:02:47 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135342#M914098 Anonymous 2016-05-24T15:02:47Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135343#M914099 <HTML><HEAD></HEAD><BODY><P>but&nbsp; i want to display&nbsp; in pivot table </P><P>as dept name </P><P>&nbsp;&nbsp;&nbsp;&nbsp; HR&nbsp; uday</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Raghu</P><P>&nbsp;&nbsp;&nbsp;&nbsp; SE Pavan </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rajesh</P><P></P><P>like this i dont want to use&nbsp; two expression i want to right it in a single expression</P></BODY></HTML> Tue, 24 May 2016 15:06:43 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135343#M914099 Anonymous 2016-05-24T15:06:43Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135344#M914100 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>If(Max(TOTAL &lt;DEPT&gt; SAL, 2) &lt;= SAL, ENAME)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125608_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Tue, 24 May 2016 15:14:38 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135344#M914100 sunny_talwar 2016-05-24T15:14:38Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135345#M914101 <HTML><HEAD></HEAD><BODY><P>Thanks&nbsp; Sunny&nbsp; its working </P></BODY></HTML> Tue, 24 May 2016 15:20:12 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1135345#M914101 Anonymous 2016-05-24T15:20:12Z