Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
pguereca
Contributor
Contributor

Exclude Value form Dimension

I have this set analysis sentence:

=if(aggr(Rank(Count(WordCounter)),Word)<=70,Word)

I have a request to remove "Among" from the Word data.

Any suggestion?

1 Reply
lironbaram
Partner
Partner

hi

try this

=if(aggr(Rank(Count({<Word-={'Among'}>}WordCounter)),Word)<=70,Word)

or this

=if(aggr({<Word-={'Among'}>}Rank(Count(WordCounter)),Word)<=70,Word)