Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GuillaumeRUE
Contributor III
Contributor III

Create a day from a specific hour

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

1 Solution

Accepted Solutions
Mathias
Partner - Contributor II
Partner - Contributor II

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)

View solution in original post

2 Replies
Mathias
Partner - Contributor II
Partner - Contributor II

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
Contributor III
Contributor III
Author

That was exactly what I needed.

Thank you!