Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Left Join Not Working (Except First Row)

Hi Community,

I'm having this issue with a left join: It only works with the first row of my Fact table.

FACT1:

LOAD fact_yymm,

     fact_code

FROM [FACT_TABLE.QVD] (qvd);

LEFT JOIN (FACT1)

LOAD fact_yymm,

     fact_ddmmyy

FROM [DATE_TABLE.QVD] (qvd);

My result:

qlik.png

Both Qvd's are attached.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

You must be using QV12 SR1. This is a known issue and should be resolved in QV12 SR 2

Left join broken in QlikView 12 SR1?

View solution in original post

3 Replies
sunny_talwar

You must be using QV12 SR1. This is a known issue and should be resolved in QV12 SR 2

Left join broken in QlikView 12 SR1?

andreas_koehler
Creator II
Creator II

Thanks Sunny,

for pointing into the right direction.

This issue nearly drove me mad.

Seems that the automatic update of my stand-alone client wasnt working. I was still at QV12 SR1.

How can such a basic function be bugged.

Happy New Year!

sunny_talwar

I am glad this was helpful.

Happy New Year my friend