Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

Like this?

Capture.PNG

Not applicable

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

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

tresesco
MVP
MVP

May be this?

Capture.PNG

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