Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Highlighted
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

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))