topic Re: Problem with left Join in QlikView

Problem with left Join

Fri, 26 Apr 2013 11:33:35 GMT

I am facing a problem here

I want to do a left join

with my left table like

Class	country
1	A
2	A
1	B
2	b

with

Country	num
A	4
B	5

I am getting 8 rows instead of 4 can anybody help me with this?

Re: Problem with left Join

Gysbert_Wassenaar — Fri, 26 Apr 2013 11:36:03 GMT

Your field names don't match so you get a cartesian product. Qlikview is case senstive. That means that country is not the same as Country. As soon as you use exactly the same field names you'll get the correct join. The same goes for values too: B is not b.

Re: Problem with left Join

sujeetsingh — Fri, 26 Apr 2013 11:46:46 GMT

See this sample ...

Re: Problem with left Join

Fri, 26 Apr 2013 11:54:23 GMT

Gysbert Wassenaar

Qlikview is case senstive. That means that country is not the same as Country. because both are treated as different fields so not make as primary key.

hence you get the wrong answer.

Re: Problem with left Join

rphpacheco — Fri, 26 Apr 2013 12:27:20 GMT

Qlikview is case senstive.

See This Sample

I put a country with a lowercase letter and one with capital for you to have a better view!

Re: Problem with left Join

Fri, 17 May 2013 04:45:08 GMT

Thanks EveryBody I figured that out .