Discussion board where members can get started with QlikView.
There are two tables call “item ” and “Working Hours ”. I want to join these table using QlikView.
I want to calculate the number of hours with in the dates ofMax_date and Min_date.
In sql I think write a join statement like this.
Item : factory, Max_date,Min_date, Team
WorkingHoures: date, factory, hours, Team
Select item.* ,sum(hours)
From item I
Inner join Working Hours WH
On I.factory = WH. factory and I.Team = WH.Team
Where I.Max_date > = WH.date >= I.Min_date
How I solve this kind of problem in QlikView.
Thanks , Im waiting your answers .
You can straightaway use this query to load into Qlikview.
SQL Select item.* ,sum(hours)
Where I.Max_date > = WH.date >= I.Min_date;
Hope it helps you.
Those data store in excel sheets. So first we have to loadthose data nw. can you give me help if don’t mind. This are the excel sheets .