topic Re: About Rank Function? in QlikView

About Rank Function?

Wed, 07 Jan 2015 15:25:53 GMT

Hi Folks,

I have a Table with Emp_ID,Sal,Deptno

I want to show only top 10 Salaries Deptno or Emp_ID

I tried Rank(sum(Sal),10) --It is not giving the proper result what i expect.

Can u plz suggest me this using Rank function only.

I tried aggr(rank(sum(Sal))<10,Deptno) --- both are not working properly.

Thanks,

rakesh

Re: About Rank Function?

priyalshah9779 — Wed, 07 Jan 2015 15:47:25 GMT

I have try to achieve this , Let me know if this helps

Thanks

Priyal

Re: About Rank Function?

Wed, 07 Jan 2015 15:54:19 GMT

Hi,

Can please post the logic Here

Re: About Rank Function?

priyalshah9779 — Wed, 07 Jan 2015 16:08:44 GMT

Dimension: DepartmentName,Employeeid

Expression :=IF(Rank(Total Sum(Salary))<4,Sum(Salary))

Thanks

Priyal

Re: About Rank Function?

anbu1984 — Wed, 07 Jan 2015 16:09:09 GMT

Dim: DeptNo

Expr: If( Rank(Aggr(Sum(Sal),DeptNo))<10,Sum(Sal))

Re: About Rank Function?

jpapador — Wed, 07 Jan 2015 16:13:15 GMT

Like others have suggested:

Dimensions: Dept No and Emp No

Expression:

If(Rank(Sum(TOTAL Sal),4) <= 10, Sum(Sal))

Re: About Rank Function?

MarcoWedel — Wed, 07 Jan 2015 17:22:15 GMT

you could also use dimension limits in your chart:

Chart properties/Dimension limits/show only largest 10 values

hope this helps

regards

Marco

Re: About Rank Function?

Thu, 08 Jan 2015 08:18:14 GMT

Hi,

Thanks for ur reply.

but it's not giving proper result

Re: About Rank Function?

Thu, 08 Jan 2015 08:21:59 GMT

Hi,

but it is giving the other departments also

Re: About Rank Function?

Thu, 08 Jan 2015 08:22:43 GMT

only using with rank() i want

Re: About Rank Function?

MarcoWedel — Thu, 08 Jan 2015 10:17:13 GMT

why?