topic How to use where condition when using join in QlikView

How to use where condition when using join

Fri, 16 Mar 2012 07:39:37 GMT

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 .

jagan — Fri, 16 Mar 2012 07:57:13 GMT

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.

Fri, 16 Mar 2012 08:40:29 GMT

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