Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

Contributor
Contributor

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

 

Cheer's

JP.