Choose Time Period

[testuser2019]

Hello,

I have a problem to choose values between a time period. I want to create a button and when you click on it the time should be between yesterday 06:00 am and today 06:00 am.

The values of yesterday before 06:00 am and today after 06:00 am should not be shown. 

Does anyone could give an advice how to solve this problem?

[aakritiv]

Create a button and in Actions add - select in field (Date field) and add the following condition :

='<='&Timestamp(Today()+(6/24))&'>='&Timestamp((Today()-1)+(6/24)) 

Attached is a sample data. 

[Brett_Bleess]

The IntervalMatch function might possibly work for you as well, I am not a very good developer, but this one struck me when I read what you were trying to do here:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...

Hopefully may work or give you some other ideas.

Regards,
Brett