Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
biob_stein
Contributor

Use outer join not for flat tables only

Dear Community,

is it possible to use an outer join also when there is no flat table desired?

Use case is as following :

We need to have all tables separated, so we have a better overview and fields are grouped by their table name. In fact it will be easier to use the data definition for ad hoc analyses in QlikView or QlikSense

I read a lot about join logics in QlikView, seems it would be enough for us to have something like outer keep, but this do not exists?

Any ideas how to achieve to get all tables seperated (not inside a flat table) loaded, but defining which connection should be a left, right and especially an outer join?

Tags (5)
2 Replies
datanibbler
Esteemed Contributor

Re: Use outer join not for flat tables only

Hi,

does the automatic linking that is done by QlikView not fulfill your requirement? That is kind of like an OUTER KEEP.

The only thing you cannot do, you cannot e.g. count the instances of a keyfield in any individual table since QlikView will then count also the instances of that keyfield elsewhere.

I haven't worked with the KEEP yet, but I see that the help_file at least does not list the possibility of an OUTER KEEP.

Best regards,

DataNibbler

biob_stein
Contributor

Re: Use outer join not for flat tables only

Hi, the automatic linking everytime cuts off data, what will be not good for ad hoc analyses, as mostly i dont know what i want to analyze before.

Example

Table A - Table B - Table C


Table B has cut off Data as its linked with Table A, But Table B can also be connected with Table C and therefore it needs all row. So we need all data of all Tables

Community Browser