topic Re: Problems with left join in QlikView

Problems with left join

Fri, 26 Jun 2015 18:05:38 GMT

Hello!

I am quite new using QV, so please forget me if my question is silly. My problem is this, I am doing an app that calculates the hour cost of a company, the problem I have right now, is that I am not able to join two tables into one, with out missing some of the data -that is bad-, I was reading other posts, and after analyzing my script and my data model, I find out that my key is no the same between tables, even though it looks the same!, here the example:

table 1:

Month	Account1	Amount1
Ene 2015	xxx	xxx
Ene 2015	xxx	xxx
Ene 2015	xxx	xxx

table 2:

Month	Account2	Amount2
Ene 2015	xxx	xxx
Ene 2015	xxx	xxx
Ene 2015	xxx	xxx

The table moved a little, but I think the problem is clear. Even though the Month is written exactly the same, in table one is to the far left and in table 2 appears to the far right, and when I take the the "Month" dimension to the presentation, as a table I have two different values for "Month", written exactly the same, but one to the far right and other to the far left.

How can I fix this? What is the script line that I am missing to make this to match? Can you please help me???

Thank you.

Re: Problems with left join

sunny_talwar — Fri, 26 Jun 2015 18:20:00 GMT

On both your tables force both months to be dates like this:

MonthName(Date#(Trim(Month), 'MMM YYYY')) as Month

Hopefully this will solve your problem

Best,

Sunny

Re: Problems with left join

Fri, 26 Jun 2015 18:23:03 GMT

it worked!!! thank you

Greetings.

Re: Problems with left join

sunny_talwar — Fri, 26 Jun 2015 18:25:04 GMT

No problem

I am glad I was able to help.

Best,

Sunny

Re: Problems with left join

sinanozdemir — Fri, 26 Jun 2015 18:25:53 GMT

When I do a left join, I don't get the same results as you get:

Re: Problems with left join

ger_alegria — Fri, 26 Jun 2015 18:29:45 GMT

probably Qlikview is taking one of the months like string and the other one like number of Month. Try to put both fields as a string or as number and see the result.

Re: Problems with left join

Fri, 26 Jun 2015 18:35:56 GMT

Yeah, those tables I draw them with the table tool here in the comment section, I am using excel tables, witch are a little more complex that this, but it worked, the trim function was the one that did the trick, thank you anyway

Greetings!