topic Re: Custom Time Buckets in QlikView

Custom Time Buckets

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Custom Time Buckets

marcus_sommer — Tue, 15 Mar 2016 12:21:52 GMT

You could use a variable or field-value (per getfieldselections) for this:

- Marcus

Re: Custom Time Buckets

Anonymous — Tue, 15 Mar 2016 12:28:37 GMT

You mean to say, by Input Variable, I can pass that value in this interval, is it?

Re: Custom Time Buckets

its_anandrjs — Tue, 15 Mar 2016 12:44:51 GMT

You have to use variables here also use input field object to fill the values to variable which is used on the slider.

Possible then share sample file.

Regards,

Anand

Re: Custom Time Buckets

marcus_sommer — Tue, 15 Mar 2016 12:56:09 GMT

I haven't used it by myself but it should work in that way.

- Marcus

Re: Custom Time Buckets

Anonymous — Tue, 15 Mar 2016 13:42:12 GMT

See the attachment & let me know if you need more info

Re: Custom Time Buckets

Anonymous — Tue, 15 Mar 2016 13:44:30 GMT

Marcus, doing that would minimize the slider time window upto that limit...

I want in a report like what I have mentioned in attachment..

Already uploaded sample, please suggest

Re: Custom Time Buckets

marcus_sommer — Tue, 15 Mar 2016 14:08:53 GMT

I think you will need to use the automatic scale which worked with a variable-switch - but you need enough space to show smaller interval unless you reduce the font-size. Have a look on the attachment if it comes near to your wished view.

I'm not sure if a slider is always a good choice for user inter-actions. Maybe a solution with normal listboxes (maybe with cyclic or drill-down grouped dimensions and/or expressions) could bring a better usability.

- Marcus

Re: Custom Time Buckets

Anonymous — Tue, 15 Mar 2016 14:15:13 GMT

No Marcus, I do want to change slider view...

In my case slider view is fixed what I shared with you earlier...

With that Slider and Input Box, I want

All the interval of Slider, From min and max value of Time Slider with the Bucket Value of Input Box.

Am I cleared?

Re: Custom Time Buckets

marcus_sommer — Tue, 15 Mar 2016 14:20:13 GMT

Have you tried to change the variable within the inputbox to a value of 60, 90, 120 for example - you will see that the bucket-size will change.

- Marcus

Re: Custom Time Buckets

Anonymous — Tue, 15 Mar 2016 16:30:06 GMT

Balraj

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

Is it closer to what you are after ?

Re: Custom Time Buckets

Anonymous — Wed, 16 Mar 2016 05:26:44 GMT

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?

Re: Custom Time Buckets

abhaysingh — Thu, 17 Mar 2016 09:42:48 GMT

Pls chck and let me know

Re: Custom Time Buckets

abhaysingh — Thu, 17 Mar 2016 11:50:09 GMT

Please find the app attached for Interval Logic

Re: Custom Time Buckets

abhaysingh — Thu, 17 Mar 2016 12:01:21 GMT

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

Re: Custom Time Buckets

MarcoWedel — Thu, 17 Mar 2016 21:47:13 GMT

Hi,

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

hope this helps

regards

Marco