Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rank

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

14 Replies
anbu1984
Master III
Master III

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

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

Not applicable
Author

Hi

,

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

anbu1984
Master III
Master III

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

jagan
Luminary Alumni
Luminary Alumni

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.

sorrakis01
Specialist
Specialist

Hi,

Try this

Regards,

Not applicable
Author

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

sorrakis01
Specialist
Specialist

Hi,

My bottom example was for you

Regards,

Not applicable
Author

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 ?

sorrakis01
Specialist
Specialist

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