Qlik Sense: Select within a date range (historical data)

markuskoessler — Thu, 25 May 2023 13:04:02 GMT

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?

Thank you and best regards,
Markus

topic Qlik Sense: Select within a date range (historical data) in App Development

Qlik Sense: Select within a date range (historical data)