topic Re: Filter data between a date and time range in App Development

Filter data between a date and time range

Daniel_G — Sat, 16 Nov 2024 00:32:02 GMT

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.

Re: Filter data between a date and time range

Ksrinivasan — Thu, 25 Feb 2021 09:42:05 GMT

hi,

your set your filter as Timestamp field,

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

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

ksrinivasan

Re: Filter data between a date and time range

Daniel_G — Thu, 25 Feb 2021 09:56:20 GMT

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.

Re: Filter data between a date and time range

agigliotti — Thu, 25 Feb 2021 10:00:27 GMT

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

Re: Filter data between a date and time range

Ksrinivasan — Thu, 25 Feb 2021 10:03:34 GMT

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.