Summary count Top N from specific date

[korn_th1]

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

[karthikoffi27se]

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

[sunny_talwar · Accepted solution]

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)

[korn_th1]

Hi Karthik
Thanks you very much for you scirpt

I test This scirpt but it is error

[korn_th1]

Dear Sunny

Thanks you very much. Thanks you very much.

Excellent Script.