Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need an intersect with setanalysis

I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)

I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)

=if ((Mat/Inns)=max(Mat/Inns), Player)

Please help.

Thanks

Ram

1 Solution

Accepted Solutions
Not applicable

Re: Need an intersect with setanalysis

In the list box under the Field use the same expression

Please see the attached QV application.

regards

Mhatim

5 Replies
Not applicable

Re: Need an intersect with setanalysis

Use = aggr(if(rank((Mat/Inn))<=10,Player),Player) instead and see the attached QV application

Regards

Mhatim

Not applicable

Re: Need an intersect with setanalysis

Thanks Mhatim. It did the trick when it came to chart. But I am trying to achieve this in a list box through an expression.

Re: Need an intersect with setanalysis

See attached file


talk is cheap, supply exceeds demand
Not applicable

Re: Need an intersect with setanalysis

In the list box under the Field use the same expression

Please see the attached QV application.

regards

Mhatim

Not applicable

Re: Need an intersect with setanalysis

Thanks Mhatim and gwassenaar

Community Browser