topic Re: Problem with joins in QlikView

Problem with joins

badri-adeel — Sat, 27 Oct 2018 08:27:38 GMT

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.

Re: Problem with joins

PrashantSangle — Sat, 27 Oct 2018 08:54:26 GMT

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

Regards,

Prashant Sangle

Re: Problem with joins

andrey_krylov — Sat, 27 Oct 2018 09:15:36 GMT

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

Re: Problem with joins

badri-adeel — Sat, 27 Oct 2018 10:44:21 GMT

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..?

Re: Problem with joins

swuehl — Sat, 27 Oct 2018 10:55:31 GMT

Bingo!

Left join broken in QlikView 12 SR1?

Upgrade your 12.0.20001.0 Version to a recent QV version.

Re: Problem with joins

badri-adeel — Sat, 27 Oct 2018 11:34:25 GMT

Thank you Stefan, you just safe my day.