Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimension Limits with a range

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

1 Solution

Accepted Solutions
Nicole-Smith

How about the attached (see the dimension).

View solution in original post

9 Replies
Not applicable
Author

Any help?

Nicole-Smith

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)

Not applicable
Author

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)

????

Nicole-Smith

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.

Not applicable
Author

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

Nicole-Smith

How about the attached (see the dimension).

Not applicable
Author

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

Nicole-Smith

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

xywen233
Contributor
Contributor

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