Qlik Sense: Select within a date range (historical data)
Hello everyone, I'm trying to select data in an app using date selection, the selected date should select the data based on two date fields.
Here my example data:
SOURCE
CUSTOMERID
SYS_START
SYS_END
ORIG
123
0001-01-01 00:00:00.000
9999-12-30 00:00:00.000
ORIG
456
0001-01-01 00:00:00.000
9999-12-30 00:00:00.000
HIST
789
0001-01-01 00:00:00.000
2023-04-21 12:21:35.223
HIST
789
2023-04-21 12:21:35.223
2023-05-04 08:08:09.226
ORIG
789
2023-05-04 08:08:09.226
9999-12-30 00:00:00.000
I am now trying to select a date from a date picker and based on the columns SYS_START and SYS_END the appropriate customer information should be selected --> the selected date must therefore lie between these two dates.
As an example: Chosen Date: 2023-05-01 should result in:
SOURCE
CUSTOMERID
SYS_START
SYS_END
ORIG
123
0001-01-01 00:00:00.000
9999-12-30 00:00:00.000
ORIG
456
0001-01-01 00:00:00.000
9999-12-30 00:00:00.000
HIST
789
2023-04-21 12:21:35.223
2023-05-04 08:08:09.226
Hopefully I was able to describe my search well and maybe someone already had a similar topic and an idea for me?
