Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Joining tables make it wrong

Hello everyone,

I got this data model.

The two tables below are calculated with group by , etc...(data inside these tables are correct)

The two tables on top are the very same one, with less and  renamed fields.(resident, data inside these tables are still correct.)

As you can see, ain't no relations between these 2 groups of tables.

I'd like to join the tables on top to make it one, but then datas are (very)wrong.

I tried all the join possibilities (left, right, concatenate, join, oute,r etc...), but still.

How can it be?

Thanks for your help

Wish you the best,

Will

2 Replies
garystrader
Contributor III

Joining tables make it wrong

Can you provide more detail than "very wrong"?  Why is it wrong?  Send an example.

Not applicable

Re: Joining tables make it wrong

Here it is sir.

there're 2 pics (right , wrong) .Pay attention to the red squares.

Community Browser