Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
daniel_sonda
New Contributor II

Left join broken in QlikView 12 SR1?

Why QlikView 12.0.20001.0 SR1 loads just 1 record with the script below?

Table1:

Load * Inline [

  Col1, Col2

  A, 1

];


Left Join (Table1)


Load * Inline [

  Col1, Col3

  A, 100

  A, 101

  A, 102

];


With previous versions, it loads 3 records.

1 Solution

Accepted Solutions
Employee
Employee

Re: Left join broken in QlikView 12 SR1?

Hi,

This is a bug and will be fixed in the next release.. My understanding that release should be around 5/2

12 Replies
MVP
MVP

Re: Left join broken in QlikView 12 SR1?

I have read about some issues with 12 SR1, for example here:

https://community.qlik.com/blogs/technicalbulletin/2016/03/14/qlikview-1200-sr1-now-available#commen...

To answer why, I think we need to wait for Qlik to answer the created bug report.

daniel_sonda
New Contributor II

Re: Left join broken in QlikView 12 SR1?

Where's the bug report? Could you send me the link?

MVP
MVP

Re: Left join broken in QlikView 12 SR1?

I was referring to the bug report Christian Wolf created and mentioned in the referenced tech bulletin's discussion.

clondono
Contributor III

Re: Left join broken in QlikView 12 SR1?

You can use the online support to log a case and report the bug:

https://qliksupport.force.com/QS_CaseWizard

Re: Left join broken in QlikView 12 SR1?

I have had a similar issue with QV 12 SR1 and had to revert back to QV12 because of this

daniel_sonda
New Contributor II

Re: Left join broken in QlikView 12 SR1?

We're doing the same right now.

rospigliosi
Contributor

Re: Left join broken in QlikView 12 SR1?

Hi , did you find a workaround for this bug?

daniel_sonda
New Contributor II

Re: Left join broken in QlikView 12 SR1?

Not yet.

We're using QV12 IR instead of SR1.

Employee
Employee

Re: Left join broken in QlikView 12 SR1?

Hi,

This is a bug and will be fixed in the next release.. My understanding that release should be around 5/2

Community Browser