Problem with joins

[badri-adeel]

I'm facing a issue specific on system, im trying to join two tables and try to get all record from both tables so i use outer join,

but im very surprise when it return all record of table one but record of table two is join with only first record.

Script:

DetailTable:

LOAD * INLINE [

Week, Key, val

1, A, 12

2, A, 24

3, A, 23

4, A, 98

5, A, 17

6, A, 15

];

Outer JOIN (DetailTable)

LOAD * INLINE [

Key, MinWeek, MaxWeek

A, 1,6

];

Logically it will be

Week	Key	val	MinWeek	MaxWeek
1	A	12	1	6
6	A	15	1	6
5	A	17	1	6
3	A	23	1	6
2	A	24	1	6
4	A	98	1	6

surprisingly when i try this on different system it return correct record but specific on my system it gives a wrong. i already tried with Unistall the Qlikview desktop remove all folders of QlikTech and then install again but no luck.

[PrashantSangle]

I tried the same code in qliksense, It is working as expected.

Regards,

Prashant Sangle

[andrey_krylov]

Hi Adeel. I don't know why it happens, I've reloaded this file and everything is fine.

[badri-adeel]

Andrey as i mention earlier it is working fine on other PC but not specifically on my system. I can't figure out the problem. previously i used this join so many time and it's working perfectly fine but suddenly it occurs.

The only solution is remain behind that re-installation of my operating system, but not sure will this work or not..?

[swuehl · Accepted solution]

Bingo!

Left join broken in QlikView 12 SR1?

Upgrade your  12.0.20001.0 Version to a recent QV version.

[badri-adeel]

Thank you Stefan, you just safe my day.