Filter data between a date and time range

[Daniel_G]

Hello community,

I am new to Qlik and wanted to know if there is a possibility to filter the data based on a date and time range. I want to see data between 25.01.2021 10:30:00 and 27.01.2021 14:38:05. I know the date picker extension where you have the possibility to select a date range. But there I don't have the possibility to restrict the time as well. Is there any way to do this? Maybe an extension?

Data Example:
...
21.02.2021 10:00:02
21.02.2021 15:05:24
21.02.2021 18:40:03
...
23.02.2021 09:28:07
23.02.2021 13:03:56
...
25.02.2021 17:05:51
25.02.2021 19:35:23
...

Result => Now I want all data between 21.02.2021 11:00:00 and 25.02.2021 19:30:00. In this case only the first and last entry should not be shown.

Example Filter:

Qlik Date Picker without time possibility:

Just adding one field which includes date and time works, but is not really user friendly.

[Ksrinivasan]

hi,

your set your filter as Timestamp field,

or

Create Date filter with =Date([Your timestamp filed],'DD-MM-YYYY')

Create Time filter with Timestamp(Your timestamp filed,'hh:mm TT')

ksrinivasan

[Daniel_G]

Hello ksrinivasan,

does it really filter all date and time events in between or does it filter all days between field 1 and alle time events between field 2.

What I want is that I get all events between the first date and time X and second date and time Y

for example my events are:
...
21.02.2021 10:00:02
21.02.2021 15:05:24
21.02.2021 18:40:03
...
23.02.2021 09:28:07
23.02.2021 13:03:56
...
25.02.2021 17:05:51
25.02.2021 19:35:23
...

Now I want all data between 21.02.2021 11:00:00 and 25.02.2021 19:30:00. In this case only the first and last entry should not be shown.

[agigliotti]

Hi @Daniel_G ,

You could use "Vizlib Calendar" extension, take a look at  https://community.vizlib.com/support/solutions/articles/35000130357-vizlib-calendar-introduction

It's free up to 5 users.

I hope it can help.

Best Regards

[Ksrinivasan]

hi,

then we will try new way,

that is create mater calendar based on Date and Time stamp (one hour  or two hour interval).

ksrinivasan.