Qualify

[gautik92]

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]

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]

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]

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

[miguelbraga]

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:

Qlikview QUALIFY & UNQUALIFY Fields by RFB 214 - YouTube

Or you can check this document:

Do you Qualify?- How to use QUALIFY statement