Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help with Rank in a set analysis

Hi all,

For the chart, i just only to display the top 2 amount for each user, and only taking the amount when indicator =S. So something like sum({<Indicator = {'S'}>}Amount ).

Thanks

J

4 Replies
MVP
MVP

Re: Help with Rank in a set analysis

Like this?

Capture.PNG

Not applicable

Re: Help with Rank in a set analysis

Thanks Tresesco,

But i want it in a bar chart. can you help? e.g. a bar chart for User A with the top 2 value added together....

Not applicable

Re: Help with Rank in a set analysis

Might need a aggr here, but i'm not sure how to do a aggr within the rank

Highlighted
MVP
MVP

Re: Help with Rank in a set analysis

May be this?

Capture.PNG

Sum({<Indicator={S}>}If(Aggr( Rank( Sum( {<Indicator={S}>} Amount)),UserName,Amount)<3,Amount))