Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
This widget could not be displayed.
1 Solution

Accepted Solutions
Preview file
9 KB
test.qvw

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.

Labels (1)
Labels
Preview file
9 KB
test.qvw
‎2016-03-29 02:50 PM

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.

Labels (1)
Labels
Preview file
9 KB
test.qvw
Contributor II
Contributor II
‎2016-03-29 02:50 PM

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.

Labels (1)
Labels
Preview file
9 KB
test.qvw
Contributor II
Contributor II
‎2016-03-29 02:50 PM

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.

Labels (1)
Labels
Preview file
9 KB
test.qvw
6,175 Views
0 Likes
6,175 Views
0 Likes
13 Replies
swuehl
swuehl
Champion III
Champion III
‎2016-03-29 04:21 PM

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.

Champion III
Champion III
‎2016-03-29 04:21 PM

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.

3,419 Views
0 Likes
3,419 Views
0 Likes
daniel_sonda
daniel_sonda
Contributor II
Contributor II
‎2016-03-29 04:41 PM
Author

In response to swuehl

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

Contributor II
Contributor II
‎2016-03-29 04:41 PM
Author

In response to swuehl

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

3,419 Views
0 Likes
3,419 Views
0 Likes
swuehl
swuehl
Champion III
Champion III
‎2016-03-29 04:57 PM

In response to daniel_sonda

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

Champion III
Champion III
‎2016-03-29 04:57 PM

In response to daniel_sonda

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

3,419 Views
3,419 Views
clondono
clondono
Creator III
Creator III
‎2016-03-29 06:41 PM

In response to daniel_sonda

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

https://qliksupport.force.com/QS_CaseWizard

Creator III
Creator III
‎2016-03-29 06:41 PM

In response to daniel_sonda

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

https://qliksupport.force.com/QS_CaseWizard

3,419 Views
3,419 Views
sunny_talwar
sunny_talwar
MVP
MVP
‎2016-03-29 10:21 PM

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

MVP
MVP
‎2016-03-29 10:21 PM

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

3,419 Views
0 Likes
3,419 Views
0 Likes
daniel_sonda
daniel_sonda
Contributor II
Contributor II
‎2016-03-30 07:32 AM
Author

In response to sunny_talwar

We're doing the same right now.

Contributor II
Contributor II
‎2016-03-30 07:32 AM
Author

In response to sunny_talwar

We're doing the same right now.

3,419 Views
3,419 Views
rospigliosi
rospigliosi
Creator
Creator
‎2016-04-05 06:54 AM

Hi , did you find a workaround for this bug?

Creator
Creator
‎2016-04-05 06:54 AM

Hi , did you find a workaround for this bug?

3,419 Views
0 Likes
3,419 Views
0 Likes
daniel_sonda
daniel_sonda
Contributor II
Contributor II
‎2016-04-05 12:43 PM
Author

In response to rospigliosi

Not yet.

We're using QV12 IR instead of SR1.

Contributor II
Contributor II
‎2016-04-05 12:43 PM
Author

In response to rospigliosi

Not yet.

We're using QV12 IR instead of SR1.

3,419 Views
0 Likes
3,419 Views
0 Likes
Bill_Britt
Bill_Britt
Former Employee
Former Employee
‎2016-04-26 10:51 AM

Hi,

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Former Employee
Former Employee
‎2016-04-26 10:51 AM

Hi,

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
3,419 Views
3,419 Views
daniel_sonda