because its giving me only 4 products, my 5th product from rank is Brand called ('xxx yyy') but another Brands are also called by for example ('xxx zzz'),('xx') and I think its a problem because Qlik cant filter this only one product called ('xxx yyy')
How can I modify this functions which find me a exact matching value not similar to this value.
In a simple way it should like this ='( ' & CONCAT(if(aggr(rank(sum([NET_SALES])), BRANDS) <= 5, 'BRANDS'),'|') & ' )' to find the same result not the similar result.
I hope you understand this case 🙂
SIMPLE WAY: HOW I CAN WRITE IN FUNCTTION ('xxx'|'yyy'|'zzz'|'ddd'|'pppp')? I cant do '(' & '''&BRAND&''' &'|' ... etc)
