Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
pguereca
New 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?

Tags (1)
1 Reply
lironbaram
Honored Contributor II

Re: Exclude Value form Dimension

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)