Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sangland2
Partner
Partner

left joins in QV11 and QV12 work differently

Hi,

Can someone please explain why in QV11 I get one row in my resulting table, but in QV12 I get two with this script:

Calendar:

LOAD * INLINE [

    calendarID,name

    2000,March Financial Year

];

left join

LOAD * INLINE [

    oid,calendarID,year

    1000,2000,'31/03/15'

    1001,2000,'31/03/16'

];


In SQL and QV11 both a left join and inner join would return two rows.

snip4.JPG

Left or Right keep join will return two rows but only one row will have the calendar name value.

In QV12 is appears to be necessary to create two separate tables to achieve the name result.

1 Solution

Accepted Solutions
rwunderlich

In both QV11 and QV12 I get two rows.

There was a bug back  in QV12Sr1 that matches what you are describing.  What release of QV12 are you using?

-Rob

View solution in original post

2 Replies
rwunderlich

In both QV11 and QV12 I get two rows.

There was a bug back  in QV12Sr1 that matches what you are describing.  What release of QV12 are you using?

-Rob

View solution in original post

sangland2
Partner
Partner
Author

Version12.0.20001.0 SR1 64-bit. I have upgraded to QV12.10.20600.0 SR8 and all sorted. thanks