topic Re: Dimension Limit in QlikView

Dimension Limit

carolin01 — Fri, 14 Mar 2014 12:55:55 GMT

Hello,

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.

Many thanks in advance for your help.

Best regards

Carolin

Re: Dimension Limit

MK_QSL — Fri, 14 Mar 2014 13:02:46 GMT

can you share your apps or sample file?

Re: Dimension Limit

carolin01 — Fri, 14 Mar 2014 13:17:51 GMT

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.

Re: Dimension Limit

daveamz — Fri, 14 Mar 2014 14:50:23 GMT

Hi,

You can filter out the negative values using something like sum({<value={">=0"}>}value).

Best regards,

David