topic AW:Re:AW:Re: Is it possible? in QlikView

Is it possible?

Fri, 09 Jul 2010 14:39:50 GMT

Dear all

A want to lnow if it's possible to do a left join with where clause, because all the time it says field doen't exist.

LEFT Join(A) Load * resident B Where A.Field = B.Field;

Best regards

Is it possible?

Fri, 09 Jul 2010 17:41:14 GMT

In Qlikview, you don't reference fields using table aliases. You also can't tell Qlikview what to join on. It's going to join the tables based on common fields. (ie: feilds of exactly the same name)

What you need to do is rename the fields in both tables, so they are the same, before you join them together.

Is it possible?

Mon, 12 Jul 2010 07:53:00 GMT

I think my question is not correctly expossed.

I want to do a left join with a between

Table 1 Fields: Country, Postal Codes, Shipment

Table 2 Fields: Country; Postal Code From; Postal Code To; Time

I want to do a left join Where Postal codes Betwwen From and To

Thanks and best regards,

AW:Re: Is it possible?

brenner_martina — Mon, 12 Jul 2010 08:01:02 GMT

Hi Jordi,

for that you have to use the function intervalmatch!

AW:Re: Is it possible?

Mon, 12 Jul 2010 08:16:19 GMT

Only one more question.

If I want to do multiple intervalmatch, how can i do that

Example

Table 1: Country, Postal Code, Arrival Hour

Table 2: Country, From Postal Code, To Postal Code, From Hour, From Hour, To Hour, Transit

Best regards.

AW:Re:AW:Re: Is it possible?

brenner_martina — Mon, 12 Jul 2010 08:23:18 GMT

Hi,

I do not understand your question, but you can enter the function intervalmatch more than once! you can also enter a loop by for counter=1 to X and next

AW:Re:AW:Re: Is it possible?

Mon, 12 Jul 2010 08:33:02 GMT

I want to know if it's possible to do an interval match for two different fields in only one sentence

Example

Table 1: Country, Postal Code, Arrival Hour

Table 2: Country, From Postal Code, To Postal Code, From Hour, From Hour, To Hour, Transit

Join table1 intervalmatch(Postal Code, Arrival Hour) Load From Postal Code, To Postal Code, From Hour, To hour Resident Table 2.

I want to do in only one senten 2 intervalmatch

First One: Postal Code between From Postal Code and To Postal Code

Second One: Arrival Hour betwwen From Hour, To Hour

Best regards,

AW:Re:AW:Re:AW:Re: Is it possible?

brenner_martina — Mon, 12 Jul 2010 08:34:48 GMT

Hi, Jordi,

no, you have to do that in two statements