topic Re: ranking in QlikView https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752651#M268210 <HTML><HEAD></HEAD><BODY><P>I want same values stay as is when no filter is made on TPK but display only 10 records</P></BODY></HTML> Thu, 19 Feb 2015 14:16:20 GMT ali_hijazi 2015-02-19T14:16:20Z ranking in pivot table https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752646#M268205 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>Got a pivot table grouping by TPK (test package) and month-year</P><P>I'm displaying for each month the ranking of the TPK for a specific expression</P><P>everything is working fine but what I want to display on the pivot is the first 10 TPKs which if I specify (TPK={$(=vHistory.TopXWasteTe)}) the ranking gives weird numbers</P><P>Please check attached document and advise</P></BODY></HTML> Thu, 19 Feb 2015 13:46:29 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752646#M268205 ali_hijazi 2015-02-19T13:46:29Z Re: ranking in pivot table https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752647#M268206 <HTML><HEAD></HEAD><BODY><P>what i want is after I get the ranking display first 10 TPKs</P></BODY></HTML> Thu, 19 Feb 2015 14:04:30 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752647#M268206 ali_hijazi 2015-02-19T14:04:30Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752648#M268207 <HTML><HEAD></HEAD><BODY><P>Hi Ali, vHistory.TopXWasteTe needs each value between single quotes, change vHistory.TopXWasteTe to:</P><P>=Chr(39) &amp; Concat(DISTINCT {&lt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RECORD_TYPE={'waste'}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,IS_WASTE={1}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Year=</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,Month=</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,MonthYear=</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,CALENDAR_DATE={'&gt;= $(vFromDate) &lt;= $(vMonthEndFromDate)'}</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,TPK={"=num(RANK(COUNT(DISTINCT</P><P>&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>&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; &lt;</P><P>&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; RECORD_TYPE={'waste'}</P><P>&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; ,IS_WASTE={1}</P><P>&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; ,Year=</P><P>&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; ,Month=</P><P>&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; ,MonthYear=</P><P>&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; ,CALENDAR_DATE={'&gt;= $(vFromDate) &lt;= $(vMonthEndFromDate)'}</P><P>&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; &gt;</P><P>&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>&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; TEST_ID</P><P>&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>&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; ,4))&lt;=$(vTopXTPK)"</P><P>&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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;}TPK, Chr(39) &amp; ',' &amp; Chr(39)) &amp; Chr(39)</P></BODY></HTML> Thu, 19 Feb 2015 14:08:14 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752648#M268207 rubenmarin 2015-02-19T14:08:14Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752649#M268208 <HTML><HEAD></HEAD><BODY><P>not accurate </P><P>click on Switch to Matrix view and see order</P></BODY></HTML> Thu, 19 Feb 2015 14:13:15 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752649#M268208 ali_hijazi 2015-02-19T14:13:15Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752650#M268209 <HTML><HEAD></HEAD><BODY><P>PAR.TPK.0002194|DEFAULT_2 is ranked 3 in Feb</P></BODY></HTML> Thu, 19 Feb 2015 14:15:08 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752650#M268209 ali_hijazi 2015-02-19T14:15:08Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752651#M268210 <HTML><HEAD></HEAD><BODY><P>I want same values stay as is when no filter is made on TPK but display only 10 records</P></BODY></HTML> Thu, 19 Feb 2015 14:16:20 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752651#M268210 ali_hijazi 2015-02-19T14:16:20Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752652#M268211 <HTML><HEAD></HEAD><BODY><P>I don't see any PAR.TPK.0002194|DEFAULT_2, it's not listed on TPK values</P></BODY></HTML> Thu, 19 Feb 2015 14:27:21 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752652#M268211 rubenmarin 2015-02-19T14:27:21Z Re: ranking https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752653#M268212 <HTML><HEAD></HEAD><BODY><P>ah sorry</P><P>check PAR.TPK.0001488|DEFAULT</P><P></P><P>without filtering its rank in Feb is 48</P><P>when filtering it gives 13</P><P></P><P>48 is the correct one</P><P>so keep displaying 48 </P></BODY></HTML> Thu, 19 Feb 2015 14:31:50 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752653#M268212 ali_hijazi 2015-02-19T14:31:50Z Re: ranking in pivot table https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752654#M268213 <HTML><HEAD></HEAD><BODY><P>SELECT FIRST JAN</P><P>see the top 10 then Feb should display the rank for the first 10 in JAN but compared to all TPKs</P></BODY></HTML> Thu, 19 Feb 2015 14:41:01 GMT https://community.qlik.com/t5/QlikView/ranking-in-pivot-table/m-p/752654#M268213 ali_hijazi 2015-02-19T14:41:01Z