Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

not included between the Start_date and the End_date of the table

Who would know the query to load data not included between 2 fields? let me explain :
I have a data table (1) with a date field (ticket_date) on each line.
And another table (2) with 2 fields dates to each line: Start_Date and End_Date

I want the data load to take only those rows in the table (1) whose ticket_date field is not included between the Start_date and the End_date of the table (2).
If you have a track I am taker.
Thank you

Community Browser