Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
samuel_lin
Contributor

User Defined Data Range Upper & Lower Bound

Dear all,

I am wondering if there's a way to allow document users to define their own upper and lower bounds easily and have the entire document updated accordingly. I look through gauge chart but didn't think it's something I want (can users define their own range using gauge instead of changing upper and lower bounds in the property?)

An example of what I am trying to do. Say I have data of the number of visits made by each person, and I'd like to see people who had made their visits for more than 4 times but less than 20 times.

Thank you very much for your help~

1 Solution

Accepted Solutions

Re: User Defined Data Range Upper & Lower Bound

You can do that with Select in Field actions assigned to the OnSelect field trigger. See this tutorial for an example with dates and calendar objects: Selecting Arbitrary Date Ranges. The technique used is identical to what you need. Instead of using two calendar objects with each one variable you can use a single slider object with two variables.


talk is cheap, supply exceeds demand
6 Replies

Re: User Defined Data Range Upper & Lower Bound

Samuel

How about using a Slider object to set 2 variables, one for minimum number and the other for maximum.

Then these 2 values can used in other objects, probably within set analysis expressions.

Best Regards,     Bill

samuel_lin
Contributor

Re: User Defined Data Range Upper & Lower Bound

Hi Bill,

Thank you for your reply. If I have set my variables: vUpperbound and vLowerbound in my Settings, how do I link these variables to my data? So that when I use slider, the rest of the data will be updated as well.

Thank you very much

Re: User Defined Data Range Upper & Lower Bound

You can do that with Select in Field actions assigned to the OnSelect field trigger. See this tutorial for an example with dates and calendar objects: Selecting Arbitrary Date Ranges. The technique used is identical to what you need. Instead of using two calendar objects with each one variable you can use a single slider object with two variables.


talk is cheap, supply exceeds demand

Re: Re: User Defined Data Range Upper & Lower Bound

Samuel

Have a look at the sheet 'What If' on the attached qvw, which is one of QlikView Example file that comes when install QlikView.

When you move a slider you'll see some of values below changing, then look at the corresponding expression to see how it works.

Here I have pasted one in.

(Sum([Sales Quantity])+(Sum([Sales Quantity])*($(vVolume)/100)))

*

(Sum([Sales Price])+(Sum([Sales Price])*($(vPrice)/100)))

Best Regards,     Bill

samuel_lin
Contributor

Re: User Defined Data Range Upper & Lower Bound

Thank you Bill. I do greatly appreciate your help.

samuel_lin
Contributor

Re: User Defined Data Range Upper & Lower Bound

Very nice tutorial, got what I need. Thanks

Community Browser