topic Create a day from a specific hour in QlikView

Create a day from a specific hour

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

Hello,

I'm under apprenticeship in France since end of 2018 and I have to upgrade Qlik documents for my compagny.

I have never used QlikView before and I'm discovering it more and more eveyday.
I would like to know if it's possible to create a chart where the dimension is a day but from 6am to 5am of the next day.

For example, if I chose 11/02/2019 as date, I should see datas from 11/02/2016 6am to 12/02/2019 5am.

For my date I have access to year,month,day,hour,minute.

Thank you in advance,

Guillaume

Re: Create a day from a specific hour

Mathias — Tue, 12 Feb 2019 09:48:51 GMT

You can create an extra field in your datamodel. The content of this field is a date based on the time of your original datefield. so for example if(time>6am, Date, Date -1 day)

Re: Create a day from a specific hour

GuillaumeRUE — Tue, 12 Feb 2019 10:26:16 GMT

That was exactly what I needed.

Thank you!