topic Use outer join not for flat tables only in QlikView

Use outer join not for flat tables only

Anonymous — Tue, 24 Mar 2015 08:16:31 GMT

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?

Re: Use outer join not for flat tables only

datanibbler — Tue, 24 Mar 2015 08:29:43 GMT

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

Re: Use outer join not for flat tables only

Anonymous — Tue, 24 Mar 2015 14:30:49 GMT

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