join structure

[Anonymous]

Hi all

i'm new to Qlikview and can't join correctly

these are my tables. i think last table must left join  with fast helper that joined with main, but it dont work correctly.

i would appreciate if anyone could help me.

[sunny_talwar · Accepted solution]

May be you need to left join your table into Main

Left Join (Main)

LOAD typName,

          typOrder,

          ..

Resident Danger_Type;

[sathishkumar_go]

Hi,

Before left join to main table from Resident Fast_Helper, do the left join (Fast_Helper)

left join (Fast_Helper)

load typName.

typOrder.

....

Resident Danger_Type;

after that, do the left join (Main)

load

danMatherId as ID,

...

Resident Fast_Helper

-Sathish

[Anonymous]

Thank you, it worked

[Anonymous]

Thank you for your help

[sunny_talwar]

Awesome, I am glad I was able to help