topic Re: Filter Data between two timestamps in QlikView

Filter Data between two timestamps

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

Hi,

I want to show data between a certain time period.

The timestamps are below :

TIMESTAMP([TSA_ROUTE_DEP_1],'YYYY/MM/DD hh:mm:ss') AS TIMESTAMP,

Example

2016/22/06 10:00:00

I built a filter into a button using a search function like (9|10|11|12|13|14|15|16|17|18|19|20|21)

and another button to filter out night times (21|22|23|00|01|02|03|04|05|06|07|08|09)

Reason being, that i want to show data for 2 different shifts. Dayshift (09:00 to 21:00) and Nightshift (21:00-09:00)

However, the date becomes problematic, as a shift starts for example at 22.06.2016 at 21:00 and ends at 23.06.2016 09:00. Thus my button searches does not take into account the date change after midnight.

Can anyone make a suggestion as to how i could filter out times between two timestamps.

Thanks in advance !

Re: Filter Data between two timestamps

varshavig12 — Wed, 22 Jun 2016 08:53:47 GMT

This can help you

I want Day & Night Employee Shift time in QV

Re: Filter Data between two timestamps

Anonymous — Wed, 22 Jun 2016 09:03:43 GMT

Identifying day and night is not the problem. the problem is that dayshift will filter out fine, however, during nightshift - the data includes day and night times because of the 12 hr time period.

So i need nightshift to include the next days data up until 9am in the morning.

for example :

22.06.2016 21:00 until 23.06.2016 09:00 because the new day starts midnight.