topic Pivot Table Ranking in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Ranking/m-p/149393#M27589 <HTML><HEAD></HEAD><BODY><P>Not sure what you're up to. Maybe this?</P><P>Child 1 =if("Total Children"&gt;=1,1,0)<BR />Child 2 =if("Total Children"&gt;=2,1,0)<BR />Child 3+ =rangemax(0,"Total Children"-2)</P></BODY></HTML> Thu, 16 Jul 2009 03:47:07 GMT johnw 2009-07-16T03:47:07Z Pivot Table Ranking https://community.qlik.com/t5/QlikView/Pivot-Table-Ranking/m-p/149392#M27588 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>How it is possible to perform a ranking on a child count for an adult using a pivot chart expression?</P><P>e.g.</P><P>Adult Total Children Child1 Child 2 Child 3+<BR />adult1 2 1 1 0<BR />adult2 4 1 1 2<BR />adult3 6 1 1 4<BR />adult4 1 1 0 0</P><P>Is there some quick function that can manage this?</P><P>Thanks,</P><P>Kevin.</P></BODY></HTML> Wed, 15 Jul 2009 23:29:07 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Ranking/m-p/149392#M27588 2009-07-15T23:29:07Z Pivot Table Ranking https://community.qlik.com/t5/QlikView/Pivot-Table-Ranking/m-p/149393#M27589 <HTML><HEAD></HEAD><BODY><P>Not sure what you're up to. Maybe this?</P><P>Child 1 =if("Total Children"&gt;=1,1,0)<BR />Child 2 =if("Total Children"&gt;=2,1,0)<BR />Child 3+ =rangemax(0,"Total Children"-2)</P></BODY></HTML> Thu, 16 Jul 2009 03:47:07 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Ranking/m-p/149393#M27589 johnw 2009-07-16T03:47:07Z