topic Re: About left join in QlikView

About left join

Mon, 10 Dec 2012 03:07:36 GMT

Hi All,

Can you help me out on the Left join?

In sql we can use those script:

Select c.CustomerName, o.Revenue

from Customers c

left join Orders o

on c.MemberId=o.MemberId and o.OrderDate >= c.CreateDate

In QV, the left join just works on the same field name, how can we achieve those condition: o.OrderDate >= c.CreateDate?

Thanks.

Re: About left join

Anonymous — Mon, 10 Dec 2012 03:09:05 GMT

Rename the OrderDate -> CreateDate or vice versa before joining and it should work the same way

Re: About left join

Mon, 10 Dec 2012 03:31:50 GMT

Hi Johannes,

Thanks for your reply, I understand we can rename that 2 fields into one to achieve the linking, however, I was wondering whether we can use like "Greate than equal to" sign to filter the record by using the Left join in QV?

Re: About left join

Mon, 10 Dec 2012 04:38:24 GMT

Hi,

i dnt think it is possible to achieve this using join only, u need to take the Resident load and apply the filter there to achieve the date comparison.

As far as renaming the date field is concerned as suggested above, i dnt understand what u wud achieve with that in terms of joining,as the field to join is Memberid, why do we need to create a composite key of

Memebrid & date which wud give completely different result ?

Regards