Discussion board where members can learn more about Qlik Sense Data Connectivity.
Hello.there is a date_start and date_end of one row and a second. If one interval is larger than the other, the result is the row with the largest interval. please help me
thank you in advance.
Try with firstsortedvalue function something like below
Temp2:Load * Inline[ID, Date_Start, Date_End66, 22.03.2021, 03.04.202170, 28.03.2021, 30.03.2021];
Inner JoinLoad FirstSortedValue(ID, Interval(Date_Start-Date_End)) as ID Resident Temp2;