Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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~
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.
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
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
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.
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
Thank you Bill. I do greatly appreciate your help.
Very nice tutorial, got what I need. Thanks