Discussion board where members can get started with Qlik Sense.
Is there a way to create a new dimension "End date" as following? whereby the end date will be the same project next phase start date minus 1 day??
LOAD * Inline [
Project, Phase, StartDate
Date(If(Project = Previous(Project), Previous(StartDate) - 1)) as EndDate
Order By Project, StartDate desc;
DROP Table Table;
I would create a key that contains the current Phase+1, and left join the table for itself.
The formula will be for -1 day is just simple =date(StartDate-1).
,Project & Phase+1 as Key
Project & Phase
Thanks, That is what exactly I want!
Thank you for your help