topic Re: Dimension Limits with a range in QlikView

Dimension Limits with a range

Tue, 26 Nov 2013 10:22:49 GMT

Hi,

In the attached qvw I want to see only Customers that are in a range of e.g. Margin% values 15%-19%.

I want the range to be specified by the user.

Any ideas?

Regards,

Helen

Re: Dimension Limits with a range

Tue, 26 Nov 2013 12:09:03 GMT

Any help?

Re: Re: Dimension Limits with a range

Nicole-Smith — Tue, 26 Nov 2013 15:12:08 GMT

Change your dimension to:

=if(aggr(Sum (Margin)/Sum(Sales), Customer)>=.15 and aggr(Sum (Margin)/Sum(Sales), Customer)<=.19, Customer)

And suppress values when null (see attached)

Re: Re: Dimension Limits with a range

Tue, 26 Nov 2013 15:45:02 GMT

Hi Nicole,

I use variables to specified the range, it works perfectly in every case exept the one that the min and the max number is the same.

=if(aggr(Sum (Margin)/Sum(Sales), Customer)>=.15 and aggr(Sum (Margin)/Sum(Sales), Customer)<=.15, Customer)

????

Re: Re: Re: Dimension Limits with a range

Nicole-Smith — Tue, 26 Nov 2013 15:57:59 GMT

It just doesn't work for .15 to .15 (it does work for .16 to .16--see attached). I'm guessing that your number is actual .14 something that is rounding up to .15 so it isn't actually equal to .15 which is why you're not getting anything on the chart.

Re: Re: Re: Dimension Limits with a range

Wed, 27 Nov 2013 08:00:12 GMT

You are right!!!

But we are using rounded numbers, so when the user gives 15 it has to be "translated" to 15.0-15.5 I suppose. Do you have any good idea about this as well?

Appriciate your help,

Helen

Re: Re: Re: Re: Dimension Limits with a range

Nicole-Smith — Wed, 27 Nov 2013 14:14:28 GMT

How about the attached (see the dimension).

Re: Dimension Limits with a range

Wed, 27 Nov 2013 14:21:21 GMT

Hi Nicole,

I had already did it myself and I forgot to inform you. Yes, that's right it works fine and I am gonna vote your answer as correct.

Thanks a lot for your time.

Regards,

Helen

Re: Dimension Limits with a range

Nicole-Smith — Wed, 27 Nov 2013 14:22:42 GMT

I'm glad you were able to get it to work

Re: Re: Re: Re: Dimension Limits with a range

xywen233 — Tue, 08 Oct 2019 08:29:18 GMT

This is really helpful and u just saved my day. Thank u so much!!