Create a day from a specific hour

[GuillaumeRUE]

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

[Mathias · Accepted solution]

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)

[GuillaumeRUE]

That was exactly what I needed.

Thank you!