Community
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
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)