Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

How to use where condition when using join

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

Re: How to use where condition when using join

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