topic Re: Set analysis..... in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810688#M1028397 <HTML><HEAD></HEAD><BODY><P>If you already have aggregated Runs scored by cricketer, then try this</P><P></P><P>Max runs batsman</P><P>Firstsortedvalue(CricketerName,-Runs)</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Min runs batsman</P><P style="font-size: 13.3333330154419px;">Firstsortedvalue(CricketerName,Runs)</P></BODY></HTML> Mon, 16 Feb 2015 07:10:53 GMT anbu1984 2015-02-16T07:10:53Z Set analysis..... https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810687#M1028396 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have some fields in my list box,Those are like cricketes names. so now i want expression for max runs batsman and min runs batsman..how to write a set analysis expression ...?</P><P></P><P>Thanks In advance</P></BODY></HTML> Mon, 16 Feb 2015 06:58:21 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810687#M1028396 prabhas277 2015-02-16T06:58:21Z Re: Set analysis..... https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810688#M1028397 <HTML><HEAD></HEAD><BODY><P>If you already have aggregated Runs scored by cricketer, then try this</P><P></P><P>Max runs batsman</P><P>Firstsortedvalue(CricketerName,-Runs)</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Min runs batsman</P><P style="font-size: 13.3333330154419px;">Firstsortedvalue(CricketerName,Runs)</P></BODY></HTML> Mon, 16 Feb 2015 07:10:53 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810688#M1028397 anbu1984 2015-02-16T07:10:53Z Re: Set analysis..... https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810689#M1028398 <HTML><HEAD></HEAD><BODY><P>Hi anbu,</P><P></P><P>i dont want like that ...i want&nbsp; like set analysis experssion...</P></BODY></HTML> Mon, 16 Feb 2015 07:31:18 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810689#M1028398 prabhas277 2015-02-16T07:31:18Z Re: Set analysis..... https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810690#M1028399 <HTML><HEAD></HEAD><BODY><P>=MaxString({&lt;Runs={'$(=Max(Runs))'}&gt;}CricketerName)</P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">=MinString({&lt;Runs={'$(=Min(Runs))'}&gt;}CricketerName)</SPAN></P></BODY></HTML> Mon, 16 Feb 2015 07:47:54 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/810690#M1028399 anbu1984 2015-02-16T07:47:54Z