set analysis exepression top batting

[gkcchowdary]

Hi guys ,

I am loading a data into qlik view through webfiles.

the fields are 1)batting. 2) R (runs)

3) W (wickets) like this .

I want display only max  and min batsmen scored.using set expressions.

[jagan]

Hi,

Try

For Max Batsman

Only(Aggr(If(Rank(Sum(Runs)) = 1, BatsMan), BatsMan))

For MinBatsman

Only(Aggr(If(Rank(-Sum(Runs)) = 1, BatsMan), BatsMan))

Regards,

Jagan.