topic Re: Summary count Top N from specific date in QlikView

Summary count Top N from specific date

korn_th1 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All Qlik Guru

Please Help me

I have Job period 10 Day.

I want summary top 10 dept. from select CALENDAR DATE and how many day of that dept.

Sample:

If I Select 5/8/2017 - 9/8/2017

Dept. Top 10 Job each day and Summary count day in top 10

Thank you for all your assistance

Re: Summary count Top N from specific date

karthikoffi27se — Thu, 10 Aug 2017 08:36:13 GMT

Hi Korn,

In the Dimension, for the Top 10 job each day please use.

=Aggr(If(Rank(Aggr(Count(Job_ID),Calendar_Date)<10, Job_ID),Calendar_Date)

And in the measure you can use the count function to count the days.

Many Thanks

Karthik

Re: Summary count Top N from specific date

sunny_talwar — Thu, 10 Aug 2017 12:06:53 GMT

Try this

Dimension

DEPT.

Expression

=Sum(Aggr(If(Div(Index('-' & Concat(DISTINCT TOTAL <CALENDAR_DATE> Num(Aggr(Rank(Count(JOB_NUMBER),1,1),CALENDAR_DATE, DEPT.), '00000'), '-', -Aggr(Count(JOB_NUMBER), CALENDAR_DATE, DEPT.)), Num(Rank(Count(JOB_NUMBER),1,1), '00000')), 6) + 1 <= 10, 1, 0), CALENDAR_DATE, DEPT.))

Look here for the way I derive the ranking

Continuous Ranking (no missing Rank)

Re: Summary count Top N from specific date

korn_th1 — Thu, 10 Aug 2017 12:50:04 GMT

Hi Karthik
Thanks you very much for you scirpt

I test This scirpt but it is error

Re: Summary count Top N from specific date

korn_th1 — Thu, 10 Aug 2017 12:57:13 GMT

Dear Sunny

Thanks you very much. Thanks you very much.

Excellent Script.