topic Creating a Calender slider object with master calendard and master time table in QlikView

Creating a Calender slider object with master calendard and master time table

exfosteve — Sat, 16 Nov 2024 20:16:56 GMT

So I've set up a master time table and a master table. For all of my my time based charts, It works fine with the following expression (

= timestamp(Date + [Time 1h],'MMM/DD hh:mm')

However, I can't seem to figure out how make a calender slider object work with hourly increments. Anyone have any ideas?

Thanks,

Re: Creating a Calender slider object with master calendard and master time table

techvarun — Tue, 13 Aug 2019 09:53:17 GMT

Pls share a sample app

Re: Creating a Calender slider object with master calendard and master time table

exfosteve — Tue, 13 Aug 2019 15:51:41 GMT

The attached QVW has a data table, a master calendar, and a master time table. I want to do time selection with a slider window at 1 hour increments, but I have not been able to get that to work.

Re: Creating a Calender slider object with master calendard and master time table

Brett_Bleess — Wed, 28 Aug 2019 18:23:06 GMT

Steve, check out the following two Design Blog posts, hopefully this will get you what you need here:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Time-Table/ba-p/1469392

There are quite a few other posts in the Design Blog area related to calendar and time etc., as well, so if the above is not what you need, use the following to do some further searching:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Creating a Calender slider object with master calendard and master time table

exfosteve — Tue, 03 Sep 2019 16:32:48 GMT

I'm still having issues. I created a slider calendar object and use the following express on the scale (= timestamp(Date + [Time 1h],'MMM/DD hh:mm'), but it treats the date and time component as invidiual items . I really want an easy way to to say (>= low time and <=hightime). Not in a script, but selecting the time range in the UI.