Discussion Board for collaboration on QlikView Scripting.
I'm new to QlikView and looking for help, how to join two tables.
I have two tables one with Activities:
And one with TimeDim:
I want to join them - to create fact table showing how much time was spend each day for ActivityType group by ActivityID:
So I want to make such sql join but in QlikView:
select ActivityId, ActivityType,DayId, calculateTimeSpend
on ( TimeDim.Dayid between Activities.StartDate and Activities.EndDate )
group by ActivityId, ActivityType, DayId
Go to Solution.
I made an application to help you. Need to be very careful to format date. I considered first as text and the format them.
Thank you cocosmina for this resolution and fast response.
I put name of month in date to make it easier to read, but i see it make it more difficult.
Thank you again for your help