Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Create a category depending on the expression result

Hi,

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 ?

Thanks

1 Reply

Re: Create a category depending on the expression result

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

Community Browser