topic Re: Qualify in QlikView

Qualify

gautik92 — Tue, 20 Oct 2015 11:54:33 GMT

If we have used Qualify in table A and ther is another table table B

cant we join table A and B using left join?

Anonymous — Tue, 20 Oct 2015 11:56:34 GMT

with qualifier you get a cartesian table

you should define the field which joins both tables

and unqualify this field

qualfiy *;

unqualify field;

left join(A)

load *

resident B

sunny_talwar — Tue, 20 Oct 2015 11:56:52 GMT

You can do one of the following:

Qualify *;

T1:

LOAD Field1,

Field2

FROM Source1

Left Join (T1)

LOAD Field1 as T1.Field1

Field3

FROM Source2

Or this:

Qualify *;

UNQUALIFY Field1;

T1:

LOAD Field1,

Field2

FROM Source1

Left Join (T1)

LOAD Field1

Field3

FROM Source2

raman_rastogi — Tue, 20 Oct 2015 12:00:09 GMT

If We have same field in both table then we can perform left join.

miguelbraga — Tue, 20 Oct 2015 12:02:44 GMT

As the others sugested you can join the two tables, but be careful because there must be atleast same key field in both tables.

Check this video in youtube that will tell you everything you need to know:

Or you can check this document: