Might try something like...
"ID MasterCalendar" as "ID Person"
// Use the same name and Qlik with perform a full outer join based on the common name autoMagically
AutoNumberHash128(Day("Start Date"), Month("Start Date"),Year("Start Date")) as "ID CalendrierStart",
AutoNumberHash128(Day("End Date"), Month("End Date"),Year("End Date")) as "ID CalendarEnd",
Keyas "ID Person";
SQL SELECT Key,
TO_CHAR (A.DATENT, 'DD/MM/YYYY') as "Start Date",
TO_CHAR (A.DATSOR, 'DD/MM/YYYY') as "End Date"
FROM Table ;
Okay, so I want my model to look like this:
The result i'm getting is a cross join where each person id = key is duplicated nrow number of the master calendar, which is not what I want.
Do i need a where clause where it knows the startdate and enddate of the person in order to give it the right master calendar id ??