topic Choose Time Period in QlikView

Choose Time Period

testuser2019 — Tue, 22 Jan 2019 10:24:02 GMT

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?

Re: Choose Time Period

aakritiv — Tue, 22 Jan 2019 12:29:45 GMT

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.

Re: Choose Time Period

Brett_Bleess — Thu, 21 Mar 2019 21:18:32 GMT

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/ScriptPrefixes/IntervalMatch.htm

Hopefully may work or give you some other ideas.

Regards,
Brett