Discussion Board for collaboration related to Creating Analytics for QlikView.
I need to create a new category (others) that contains all the countries that have Sales less than 5% of the total.
I used this:
If(sum(Sales)/ sum(<TOTAL> Sales)<0.05, 'Others', Country)
I put this in the Dimension but it doesn't work (it generates an error).
Can you help me please to fix that ?
You can use dimension limit tab,
check the box Limit, and the option: show only values greater than 5%
then check "others"
Let me know