topic Re: How to get Top10 in pivot in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83073#M784080 <HTML><HEAD></HEAD><BODY><P>Can you share expected output in an excel file?</P></BODY></HTML> Sat, 10 Mar 2018 16:57:14 GMT sunny_talwar 2018-03-10T16:57:14Z How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83072#M784079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table like below. I want top 10 based on county,Client Normalized and Sourcing method = 'Targeted Work order</P><P></P><P>And also how to hide Sourcing method column however i want to see requisitioned an Targeted work order.</P><P></P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195963_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83072#M784079 savithri_n_s 2020-11-25T16:16:04Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83073#M784080 <HTML><HEAD></HEAD><BODY><P>Can you share expected output in an excel file?</P></BODY></HTML> Sat, 10 Mar 2018 16:57:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83073#M784080 sunny_talwar 2018-03-10T16:57:14Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83074#M784081 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195964_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sat, 10 Mar 2018 17:00:27 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83074#M784081 savithri_n_s 2018-03-10T17:00:27Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83075#M784082 <HTML><HEAD></HEAD><BODY><P>This</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195961_Capture.PNG" style="height: 225px; width: 620px;" /></P></BODY></HTML> Sat, 10 Mar 2018 17:08:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83075#M784082 sunny_talwar 2018-03-10T17:08:48Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83076#M784083 <HTML><HEAD></HEAD><BODY><P>Can you share your data? excel file..</P><P></P><P>For top 10 please use top function in the main script. Sourcing method column is normal column or calculated one? We do have option to hide column in straight table but in pivot table there is no such option. You have to use macros.</P></BODY></HTML> Sat, 10 Mar 2018 17:12:49 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83076#M784083 isingh30 2018-03-10T17:12:49Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83077#M784084 <HTML><HEAD></HEAD><BODY><P>Sunny is it possible to display only first top 10 . As we see 12 lines</P></BODY></HTML> Sat, 10 Mar 2018 17:13:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83077#M784084 savithri_n_s 2018-03-10T17:13:17Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83078#M784085 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195966_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>This how it should look</P></BODY></HTML> Sat, 10 Mar 2018 17:17:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83078#M784085 savithri_n_s 2018-03-10T17:17:43Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83079#M784087 <HTML><HEAD></HEAD><BODY><P>I want top 10 in pivot based on # of non Competitive Rate WO.Can you please help? This in dashboard 11 of qvw file and 2nd table.</P><P></P><P>Below is the output I am looking for</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195976_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sun, 11 Mar 2018 15:29:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83079#M784087 savithri_n_s 2018-03-11T15:29:40Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83080#M784089 <HTML><HEAD></HEAD><BODY><P>have a look <STRONG>sheet 13</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Use as Calculated Dimension:<BR /></STRONG></P><P><STRONG>=AGGR(IF(Rank(Count({&lt;[Comp vs Non-Comp] = {'Not Competitive'}&gt;}[Contractor Name]),4)&lt;=10,[Client - Normalized]),[Client - Normalized])</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="195991" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195991_Capture.JPG" style="height: auto;" /></STRONG></P></BODY></HTML> Mon, 12 Mar 2018 06:57:27 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83080#M784089 Nagaraju_KCS 2018-03-12T06:57:27Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83081#M784091 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Mon, 12 Mar 2018 13:30:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83081#M784091 savithri_n_s 2018-03-12T13:30:19Z Re: How to get Top10 in pivot https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83082#M784092 <HTML><HEAD></HEAD><BODY><P>Please close the thread.!</P></BODY></HTML> Mon, 12 Mar 2018 14:18:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-Top10-in-pivot/m-p/83082#M784092 Nagaraju_KCS 2018-03-12T14:18:26Z