topic Re: Rank in QlikView

Rank

Anonymous — Fri, 10 Oct 2014 05:45:22 GMT

Hi, how to calculate the highest rank and lowest rank in two separate text box?

Re: Rank

anbu1984 — Fri, 10 Oct 2014 05:49:53 GMT

Min(Aggr(Rank(Field),Dim))

Max(Aggr(Rank(Field),Dim))

Re: Rank

Fri, 10 Oct 2014 07:24:08 GMT

Hi anbu cheliyan

I tried to work on the same post, and try with your answer

i am getting some wrong answer in my text box, even though answer should be 3 instead of four,because my table EMP have only three departments at all.

can u please help me out why is this gonna happn??

Re: Rank

anbu1984 — Fri, 10 Oct 2014 07:40:19 GMT

You should get 3. Do you have any other tables linked to your EMP table?

Re: Rank

jagan — Fri, 10 Oct 2014 07:51:02 GMT

Hi,

Try like this

For Minimum Rank:

=Min(Aggr(Rank(Sum(MeasureName)), DimensionaName))

For Maximum Rank:

=Max(Aggr(Rank(Sum(MeasureName)), DimensionaName)) - 1

Regards,

Jagan.

Re: Rank

sorrakis01 — Fri, 10 Oct 2014 07:52:29 GMT

Hi,

Try this

Regards,

Re: Rank

Fri, 10 Oct 2014 07:55:03 GMT

I have one table i.e. calendar linked to it. I think it shoul not affect count at all.

Re: Rank

sorrakis01 — Fri, 10 Oct 2014 08:00:01 GMT

Hi,

My bottom example was for you

Regards,

Re: Rank

Fri, 10 Oct 2014 08:02:14 GMT

Yes i have seen your example ... but still in confusion why difference is there, where i am using same approach. it might be because calendar linked table ?

Re: Rank

sorrakis01 — Fri, 10 Oct 2014 08:07:26 GMT

Hi,

It's a possibility, because you have only 3 DEPTNO¿?

If you like you can upload the project and maybe can i help you.

Regards

Re: Re: Rank

sorrakis01 — Fri, 10 Oct 2014 08:11:18 GMT

Resolve,

You have a DEPTNO to NULL

Look the example.

Regars,

JAG

Re: Rank

Fri, 10 Oct 2014 08:12:07 GMT

see above... already uploaded named as 1000_calendar.qvw

thanks

Re: Rank

anbu1984 — Fri, 10 Oct 2014 08:15:49 GMT

Check the result of this expr

=Concat(DISTINCT Aggr(DEPTNO,DEPTNO) & ',' & Aggr(Sum(SAL),DEPTNO) & ',' &Aggr(Rank(Sum(SAL)),DEPTNO),Chr(10))

Re: Rank

Fri, 10 Oct 2014 08:16:39 GMT

Yes thanks alot

Re: Rank

sorrakis01 — Fri, 10 Oct 2014 08:18:59 GMT

Welcome

Close the discussion.

C y

JAG