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!

[Anil_Babu_Samineni]

May be this?

If(Rank(Sum([UL Count])/Sum([Total UL Count]))=1, [UL Count])

[Chanty4u]

try this

text box

=[UI Count]&' '& Rank

[surendraj]

May be This!!

Only({<Rank={1}>}[UI Count])

[seahyanzheng]

It returns blank though.

Do i have to aggr "Rank(Sum([UL Count])/Sum([Total UL Count]))"?

[seahyanzheng]

I need to return only 1st rank though

[Anil_Babu_Samineni]

How you got [UL Count %] ??

[seahyanzheng]

As Rank is an expression with Rank(total "UL Count"/"Target UL Count"), i tried this instead:

Only({<Rank(total "UL Count"/"Target UL Count")={1}>}[UI Count])

but i got error in set modifier expression

[seahyanzheng]

With this expression - UL Count /Target UL Count

[surendraj]

I thought you need to do in separate way..first you need to calculate rank then you can try with above expression.it will works.