Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the SenseDate Range Picker from the developer page.. I'm trying to solve an issue with relative time. I want the dashboard to show today's data but if the dashboard is open over the course of 24+ hours I want it to refresh with the next days data.. For example: the date range picker has a selection of Today which is 1/16.. The dashboard is projected on a screen 24/7 so at midnight I want the dashboard to start displaying 1/17 data.
Note: I'm not using the Qlik Sense supported date range picker because when I select a day in the supported date picker, it chooses the following day. So right now, I need solutions that work for the Sense Date Range picker which can be found at: https://developer.qlik.com/garden/5697a878dcc497f80ed514bf for reference
Thanks in advance!
I'm not sure if I fully understand the solution... So I use timestamp(floor(timestamp#(logicalDate))) as logicalDate because my date picker is on that field and now when 'Today' is selected in the date range picker and the dashboard is left open over night it will automatically change the filter to the following day (which would then be 'today')? Or is there more I need to do?