Index Match in Qlikview?

[seahyanzheng]

Hi,

I have UL Count and Target UL Count as dimension , UL Count % as UL Count /Target UL Count and Rank as the rank function.

How do i create a text box where i pull UL count (eg. 70) when Rank = 1?

Thanks!

[seahyanzheng]

=concat(If(aggr(Rank(Sum([UL Count])/Sum([Total UL Count])),[UL Count])=min( total aggr(Rank(Sum([UL Count])/Sum([Total UL Count])),[UL Count])), [UL Count]),',')

It returns Rank 29 too.

Below is the screenshot:

[Anil_Babu_Samineni]

When you say sample, It's working fine that means are you using this expression for provided image? Or it is going to new stuff. Can you share sample file where and which is not working for you, We will test the same

[seahyanzheng]

Thanks for the help!

This is what i have got for the two expressions:

[seahyanzheng]

I realized is my data issue.. otherwise the above expression should works! Thanks Anil Babu!

[seahyanzheng]

Thanks everyone for the enormous help!