Discussion board where members can get started with Qlik Sense.
From Help file
|daystart('25/01/2013 16:45:00')||Returns 25/01/2013 00:00:00.|
|daystart('25/01/2013 16:45:00', -1)||Returns 24/01/2013 00:00:00.|
|daystart('25/01/2013 16:45:00', 0, 0.5 )||Returns 25/01/2013 12:00:00.|
can you explain more about "period_no". I'm not really understand about that. As example, I want to start at 8 am everyday and I am able to see the history of the data (> a week ago) . Much appreciate if u can help me to get better understanding.
|period_no||period_no is an integer, or expression that resolves to an integer, where the value 0 indicates the day that contains time. Negative values in period_no indicate preceding days and positive values indicate succeeding days.|
Can you elaborate more on the context in which you are looking for a 8AM day start? This function converts a timestamp to a day start time. Is that actually what you are looking for?
Think of the period_no as an offset which you apply to the timestamp the function evaluates.
Are you trying to return data with a certain date and time range?
like from 29/08/2016 8AM to Today 8AM ?