Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
biob_stein
Creator
Creator

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?

2 Replies
datanibbler
Champion
Champion

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
Creator
Creator
Author

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