filter by date problem

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

Hello everybody,

I have a production log that covers every manufacturing cycle. The protocol saves a timestamp at the beginning and at the end. If I want to filter the data for a certain period, I have to choose a combination of calendar week and day. If I filter everything by date using the date (timestamp) function, I get the date as a filter function for each production cycle.

For example:
10/10/19 10:10:10 start
10.10.19 10:11:11 end

10/10/19 11:11:11 start
10.10.19 11:12:12 End

I get the filter 10.10.19 twice and it stands for only one production cycle.

Does anyone know how to solve this problem so that I can filter by date?

Thank you,
Dominic

Re: filter by date problem

m_woolf — Wed, 15 May 2019 12:24:47 GMT

In script, load the date as floor(Date)

topic filter by date problem in QlikView

filter by date problem

Re: filter by date problem