If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Need your help in the below requirement,
I have two Tables
I want the result to be like this in the End table. Is there any way we can do this in Back end.
Date#("Allocation Months",'MMM-YY') As "Allocation Months",
(html, utf8, embedded labels, table is @1);
Date#("AllocationStart",'MMM-YY') As Start,
Date#("Allocation End",'MMM-YY') As End
(html, utf8, embedded labels, table is @2);
Left Join IntervalMatch ("Allocation Months", Project)
Load Start, End, Project
Drop table Data, Interval;
Load Project, Start, End, Sum(Hrs) As TotalHours
Group by Project, Start, End;
Drop table _tmp;
If you don't want the project with out start and end (not in the interval table), just change the Left Join to Inner Join.
I also attached a demo app for you.
View solution in original post
Thank you it worked...!!!