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

Problem Seeing Full Data

Hi.

I have an excel table loaded with this data

YearMonthCar         Expense

201411                    100

201421                    100

201431                    100

Sql table with this data

YearMonthCar     Income

201411               100

201431               300

The common key- is YearMonthCar

when i load the data in qlikview table the data from second row from excel table is missing.

I understand why because of the join,

but how do i fix it?

4 Replies
datanibbler
Esteemed Contributor

Re: Problem Seeing Full Data

Hi,

by default, QlikView does an inner join - which means only those records present in BOTH tables are in the output.

If you load your Excel table first, use a LEFT JOIN - that will keep all those records that are in the primary_table (which would be your Excel table), whether they match or not - and add those records from the other table that match.

The best and easiest way to visualize the different kinds of JOINs is, I think, with two overlapping circles.

Re: Problem Seeing Full Data

What kind of join have you done? You need a full join (not left or right), send me your script (or document)

Not applicable

Re: Problem Seeing Full Data

the problem is that my primary table is the one from sql

satyadev_j
Valued Contributor

Re: Problem Seeing Full Data

Hi,

You may have to use trim function to remove unwanted space from start and end of data before join them. Sometimes in excel we get space at the end of data.

Trim(YearMonthCar) as YearMonthCar