Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sum with exclusion

Dear Members,

The below code is working fine but I need to include an exclusion on it like "Group name != Retailer"

=if($(xTop)=10,if(aggr(Rank(Sum($(vGros2))),[Group Name]) <=10,[Group Name]))


With exclusion (Not working)

=if($(xTop)=10,if(aggr(Rank(Sum($(vGros2))),{<[Group Name]-={"Retailer"}>}) <=10,[Group Name]))

 

Please enlighten me.


Much appreciated for the help.

Cheer's

JP.

Labels (1)
1 Solution

Accepted Solutions
Highlighted

May be try this

=if($(xTop)=10,if(Aggr(Rank(Sum({<[Group Name] -= {"Retailer"}>} $(vGros2))), [Group Name]) <=10, [Group Name]))

View solution in original post

2 Replies
Highlighted

May be try this

=if($(xTop)=10,if(Aggr(Rank(Sum({<[Group Name] -= {"Retailer"}>} $(vGros2))), [Group Name]) <=10, [Group Name]))

View solution in original post

Highlighted
Contributor
Contributor

Dear Sunny, it work like charms.    Thank you for the help.

 

Cheer's

JP.