topic Re: Rank top 10 in QlikView

Rank top 10

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

Hello All,

I am trying to only show the top 10 projects in a line chart. I am unable to use the Dimension Limits to do this. I have two expression that I would like to put the "rank function" in. Just do not know where it should go or how it works.

Formula 1: Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS))

Formula 2: Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)

Re: Rank top 10

Anonymous — Tue, 10 Oct 2017 13:59:51 GMT

What is the Dimension , you will require to choose top project ?

Hours Or date ?

Re: Rank top 10

mparker123 — Tue, 10 Oct 2017 14:01:40 GMT

I want to show the top 10 based on the number of Hours they have.

Re: Rank top 10

Anonymous — Tue, 10 Oct 2017 14:04:22 GMT

=if(Aggr(Rank(Sum(Hours)), DEPT)<=10, DEPT , 'Others')

Re: Rank top 10

mparker123 — Tue, 10 Oct 2017 14:09:58 GMT

I need to keep the formulas above I just want to add top 10 into the expression

Re: Rank top 10

sunny_talwar — Tue, 10 Oct 2017 14:10:05 GMT

You want to look at top 10 based on rank of which expression?

Re: Rank top 10

mparker123 — Tue, 10 Oct 2017 14:12:53 GMT

I have two charts each expression is in a different chart so I need the top 10 of both formulas based on the number of Hours.

Re: Rank top 10

its_anandrjs — Tue, 10 Oct 2017 14:19:13 GMT

Can you share some sample data for this.

Re: Rank top 10

mparker123 — Tue, 10 Oct 2017 14:24:15 GMT

Unfortunately I can not.

Re: Rank top 10

Anonymous — Tue, 10 Oct 2017 14:30:48 GMT

Like this ?

rank(sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)<=10)

Re: Rank top 10

sunny_talwar — Tue, 10 Oct 2017 14:42:22 GMT

May be this

If(Rank(Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS))) < 11, Sum(If(week(Date(Today()-4*7)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS)))

If(Rank(Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS)) < 11, Sum({<DEPT={"44840"},epic_status-={"Not Required","Done"}>}HOURS))

Re: Rank top 10

Anonymous — Tue, 10 Oct 2017 14:44:33 GMT

kudos to sunny ,,