Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Slider and GetObjectField function


Hi,

I am using a slider object to determine how many computers are remaining to be upgraded at a particlar date and time. A particular Date and Time is selected by the Slider and its input comes from from "Slider Date" column from the Table. When a user selects a date from the slider, the output must display, "the number of Computers" where the "Upgrade Date" is 'After" the "Selected" Slider Date. In the appended table, if we select row 5 as Slider input, Slider Date "01/31/2014 10:45 AM", then the output is 3. Three computers were waiting for upgrade - Computer3, Computer4, and Compurt5, because their upgrade date is "After" the selected Slider Date. Computer1 already started upgrade process at 10:10 am and Compter2 started 10:20 and, so they are excluded from the count. We also do not want to count computers beyond the selected "Slider Date", whcih in this case is row 6 through row 10.

I use Slider object with "Slider Date" as Data Field input, with Mode "Single Value".

I want to use "Table" object to display Numbers. I used no dimension. I used "GetObjectField" function to get the date field, but it does not provide any output. Can comeone help me understand how to get the "Value" from the slider and use it as input to "Table"? I appreciate. Thanks,

ItemsSlider DateUpgrade Date
1Computer11/31/2014 10:08 AM1/31/2014 10:10 AM
2Computer21/31/2014 10:16 AM1/31/2014 10:20 AM
3Computer31/31/2014 10:20 AM1/31/2014 11:25 AM
4Computer41/31/2014 10:30 AM1/31/2014 12:23 AM
5Computer51/31/2014 10:45 AM1/31/2014 1:19 PM
6Computer61/31/2014 10:56 AM1/31/2014 1:41 PM
7Computer71/31/2014 12:01 PM1/31/2014 1:32 PM
8Computer81/31/2014 12:21 PM1/31/2014 2:03 PM
9Computer91/31/2014 12:12 PM1/31/2014 2:38 PM
10Computer101/31/2014 12:42 PM1/31/2014 2:29 PM

Message was edited by: Raghavendra Rao I poseted QVW file

11 Replies
Not applicable
Author

Hi Rupert,

I agree with you about the date conversion in Qlik. It is tricky. I will apply the logic you suggested in a simple test file later and test it. Currently we removed the slider function.

Thanks,

Raghu

Not applicable
Author

Hi Nancy,

I applied the logic you suggested. It displays the correct counts for some range. It works partially. I removed the slider from the application.

Thanks,

Raghu