Sequential Dates from multiple tables in Qlik Sense
Hello, I have three tables, "Worked", "Edited" and "Pay" joined by a primary key. They each have a date field that should be sequential, a "worked date field", then a possible "edited date field" and a "pay date field". When I put them in a table or a pivot it will show the correct "worked date" and "pay date", but because there is not always an "edited" field, it keeps repeating the dates in multiple rows and they aren't even sequential to the worked date. Any insight or help would be appreciated.
