topic Re: Multiple joins in single QVD Tab in QlikView

Multiple joins in single QVD Tab

ashishpalkar — Tue, 29 Sep 2015 21:44:05 GMT

Hi There

I have below requirement.

I have 5 Tables

Table1

(ID -> Primary Key) - Fact Table

ID1

ID2

ID3

ID4

Table2 (ID1 ->Primary Key) -

Table3 (ID2 ->Primary Key)

Table4 (ID3 ->Primary Key)

Table5 (ID4 ->Primary Key)

Table 2 to 5 are connected with Table 1 using above respected ID's. How can we use this in one single QVD?

Thanks in advance,

Re: Multiple joins in single QVD Tab

sunny_talwar — Tue, 29 Sep 2015 22:08:39 GMT

Are you trying to save these 5 tables in a single QVD file? If you are then just perform a (Regular, Left, Right or Inner) Join operation to create one table out of the 5 and save them in a qvd.

Re: Multiple joins in single QVD Tab

sunny_talwar — Tue, 29 Sep 2015 22:09:36 GMT

Re: Multiple joins in single QVD Tab

Peter_Cammaert — Tue, 29 Sep 2015 22:25:58 GMT

If you're looking for a way to store an entire data model in a single QVD, why not store it in a headless QVW and perform a BINARY load whenever you need the data somewhere else?

Peter

Re: Multiple joins in single QVD Tab

ashishpalkar — Wed, 30 Sep 2015 02:49:02 GMT

Hi Peter

Thanks for updates , what is headless QVW?

Re: Multiple joins in single QVD Tab

SreeniJD — Wed, 30 Sep 2015 03:45:40 GMT

Hi Ashish -

In general, an application is a QlikView file that is used as a ‘headless’ (i.e. UI-less) optimized application containing data– known as a .qvd file. it’s important for those responsible for the deployments to employ a multi-tiered data and application architecture approach

HTH

Sreeni

Re: Multiple joins in single QVD Tab

ashishpalkar — Wed, 30 Sep 2015 04:15:04 GMT

thanks Sreeni for updates, can you send me any sample file with mentioned criteria.

(I have created 5 different QVD's and then joining these QVD's with appropriate Primary keys)

Re: Multiple joins in single QVD Tab

ashishpalkar — Wed, 30 Sep 2015 14:34:06 GMT

Thanks Sunny.