https://community.qlik.com/t5/App-Development/Sequential-Dates-from-multiple-tables-in-Qlik-Sense/m-p/2503631#M103631 <P>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.&nbsp;</P> Wed, 29 Jan 2025 22:05:29 GMT lbrooks3 2025-01-29T22:05:29Z https://community.qlik.com/t5/App-Development/Sequential-Dates-from-multiple-tables-in-Qlik-Sense/m-p/2503631#M103631 <P>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.&nbsp;</P> Wed, 29 Jan 2025 22:05:29 GMT https://community.qlik.com/t5/App-Development/Sequential-Dates-from-multiple-tables-in-Qlik-Sense/m-p/2503631#M103631 lbrooks3 2025-01-29T22:05:29Z https://community.qlik.com/t5/App-Development/Sequential-Dates-from-multiple-tables-in-Qlik-Sense/m-p/2503657#M103636 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/21078">@lbrooks3</a>&nbsp;Check below article.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578" target="_blank">https://community.qlik.com/t5/Design/Canonical-Date/ba-p/1463578</A></P> Thu, 30 Jan 2025 05:04:07 GMT https://community.qlik.com/t5/App-Development/Sequential-Dates-from-multiple-tables-in-Qlik-Sense/m-p/2503657#M103636 Bhushan_Mahajan 2025-01-30T05:04:07Z