Solved: Re: Rank top 10 - Qlik Community

mparker123 · ‎2017-10-10

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)

sunny_talwar · ‎2017-10-10

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))

View solution in original post

Anonymous · ‎2017-10-10

Hi

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

Hours Or date ?

mparker123 · ‎2017-10-10

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

Anonymous · ‎2017-10-10

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

mparker123 · ‎2017-10-10

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

sunny_talwar · ‎2017-10-10

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

mparker123 · ‎2017-10-10

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.

its_anandrjs · ‎2017-10-10

Can you share some sample data for this.

mparker123 · ‎2017-10-10

Unfortunately I can not.

Anonymous · ‎2017-10-10

Like this ?

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