Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use where condition when using join

Hi All,

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.

tables are

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 .

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can straightaway use this query to load into Qlikview.

TableName:

SQL 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;

Hope it helps you.

Regards,

Jagan.

Not applicable
Author

thanks Jagan.

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 .

thanks

Savi