Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

filter by date problem

 
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.

date.png
 
Does anyone know how to solve this problem so that I can filter by date?
Thank you,
Dominic
1 Reply
Highlighted
Master II
Master II

Re: filter by date problem

In script, load the date as floor(Date)