I´m trying to implement a dimension limit with a variable as follows:
My values are sorted descending by expression which I use in the first column and without the restriction you wouldn´t see the negative values. But as soon as I enable the restriction Qlik View only shows me the first few value until the value of the variable (here 10%) is achieved. And then it shows the negative values. It should stop showing customers as soon as e.g. 10% are achieved. In any case the negative values are not the next in line of the sorting. How can I avoid this? The reason why I´m trying to do this is that I use the variable also for a slider and with this slider I would like to be able to see e.g. the customers which contribute to e.g. 10% of the sales.
I think the solution would be if I could exclude negative values. If my field is e.g. SoldToBusinessPartner then I don´t wanna see zero and negative results. I´m not sure how I can post my app, I don´t have an example app. I tried it by reducing data and scrambling but after scrambling it didn´t show any values anymore.
