Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinni2000
Contributor III
Contributor III

Filter data between a date and time range Hello community, I am new to Qlik and wanted to know if there is a possibility to filter the data based on

Filter data between a date and time range
 

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:

 

Filter data between a date and time range Hello community, I am new to Qlik and wanted to know if there is a possibility to filter the data based on Just adding one field which includes date and time works,

we can use that timestamp field as direct filter but its not really user friendly.

is there is any other way to do

 

 

0 Replies