Custom Time Buckets

[Anonymous]

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

[Anonymous]

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]

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 · Accepted solution]

Pls chck and let me know

[abhaysingh]

Please find the app attached for Interval Logic

[abhaysingh]

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:

hope this helps

regards

Marco