topic Re: Ranking in Pivot table showing only TOP x Job Codes in QlikView

Ranking in Pivot table showing only TOP x Job Codes

tmumaw — Wed, 19 Sep 2018 11:53:39 GMT

Hi all,

I am trying to show the top 5 or 10 job codes across 5 years. Sort of having a problem getting it to work. Any ideas? For example I need to show the Top 5 Job Codes for each year. Here is my Rank statement: Rank(count({<InActive = {1},YTDFlag = {1}>} DISTINCT([Employee Number])))

And I sort based on Job with this : descending on this count({<InActive = {1},YTDFlag = {1}>} DISTINCT([Employee Number]))

Thanks

Re: Ranking in Pivot table showing only TOP x Job Codes

YoussefBelloum — Wed, 19 Sep 2018 12:27:22 GMT

Hi,

so what is the expected output here ? would you be able to surround the lines using the image above ?

Re: Ranking in Pivot table showing only TOP x Job Codes

tmumaw — Wed, 19 Sep 2018 13:43:37 GMT

I would like to see the Top 5 jobs for each year based on Term Emps. Ignore the rank for right now.

Re: Ranking in Pivot table showing only TOP x Job Codes

YoussefBelloum — Wed, 19 Sep 2018 14:15:26 GMT

ok, just share your data structure and I'll try to populate a table with the same structure and share a QVW

Re: Ranking in Pivot table showing only TOP x Job Codes

tmumaw — Wed, 19 Sep 2018 14:41:18 GMT

Forgot to add the spreadsheet thanks

Re: Ranking in Pivot table showing only TOP x Job Codes

YoussefBelloum — Wed, 19 Sep 2018 14:44:59 GMT

is that your original file or it is an extraction from a pivot table ?

if you want to load that file, you will need to make a crosstable on the script

Re: Ranking in Pivot table showing only TOP x Job Codes

tmumaw — Wed, 19 Sep 2018 15:07:43 GMT

That's a dump from the already created pivot table.

Re: Ranking in Pivot table showing only TOP x Job Codes

YoussefBelloum — Wed, 19 Sep 2018 15:13:21 GMT

would you be able to attach a sample with the original file structure ? because with a pivot structure I'll need to do a crosstable and I'm not sure I will get your original structure

Re: Ranking in Pivot table showing only TOP x Job Codes

tmumaw — Thu, 20 Sep 2018 12:16:28 GMT

Youssef,

Thanks for your help. My user called yesterday afternoon and wanted to go a different route other than Top 5 by year. Go figure.