topic Re: join structure in QlikView

join structure

Anonymous — Wed, 17 Feb 2016 08:40:05 GMT

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 — Thu, 18 Feb 2016 18:05:29 GMT

May be you need to left join your table into Main

Left Join (Main)

LOAD typName,

typOrder,

Resident Danger_Type;

sathishkumar_go — Thu, 18 Feb 2016 18:17:07 GMT

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 — Sun, 21 Feb 2016 06:12:05 GMT

Thank you, it worked

Anonymous — Sun, 21 Feb 2016 06:12:38 GMT

Thank you for your help

sunny_talwar — Sun, 21 Feb 2016 14:00:38 GMT

Awesome, I am glad I was able to help