Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Custom Time Buckets

Qlikers,

Need your suggestion for a scenario....

I am having a slider object for a Time window say 11:30 - 11:30 with Min and Max Time stamp variable..

Now, I want to give a flexibilty to user with a option of 10 min, 20 min, 30 min, 40 min, 60 min , 90 min and so on window which I can create a inline for same(Any other option apart from Inline, appreciatable)

When User select or tick 10 min, then I want data & analysis like

(Min Value of Slider)11:30 - 11:40

11:40 - 11:50

11:50 - 12:00

12:00 - 12:10

and so on till Max Value of slider...

Similarly, if user selects or tick 20 min, then I should get like this


(Min Value of Slider)11:30 - 11:50

11:50 - 12:10

12:10 - 12:20

12:20 - 12:30

and so on till Max Value of slider...


How can I achieve same?


If I am not wrong, then might be use of Variable & Triggers or any other?


Any suggestion highly appreciatable

15 Replies
Anonymous
Not applicable
Author

Balraj

I have fiddled with Marcus's qvw and attached my version with a few changes.

Is it closer to what you are after ?

Anonymous
Not applicable
Author

Bill,

This is really helpful...

Just want to check, you have taken Field in slider but I need to customized this slider with a time window from 11:30 to 11:30..

FYI....here 11:30 -23:59 is Current date & 00:00 - 11:30 is next date time

Would it be possible?

abhaysingh
Specialist II
Specialist II

Pls chck and let me know

abhaysingh
Specialist II
Specialist II

Please find the app attached for Interval Logic

abhaysingh
Specialist II
Specialist II

use input in LET  variable to feed the time in variable. tested its working

MarcoWedel

Hi,

though already closed I want to add another solution to this thread:

QlikCommunity_Thread_209552_Pic1.JPG

QlikCommunity_Thread_209552_Pic2.JPG

QlikCommunity_Thread_209552_Pic3.JPG

QlikCommunity_Thread_209552_Pic4.JPG

QlikCommunity_Thread_209552_Pic5.JPG

hope this helps

regards

Marco