Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkcchowdary
Contributor

set analysis exepression top batting

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.

1 Reply
MVP
MVP

Re: set analysis exepression top batting

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.

Community Browser