Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
pratik_advani
Contributor
Contributor

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

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

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

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

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