topic Re: Hierarchies and Synthetic Views in QlikView

Hierarchies and Synthetic Views

Fri, 20 Jul 2012 19:25:23 GMT

Hi all,

I am an intern, and before today my hierarchy worked beautifully on v9, but as of today, Qlikview insists on creating a synthetic join within the hierarchy. The synthetic join alters the way it views the dollar data, and yield incorrect results. Inserting a QUALIFY *; breaks the update.

Here is an image of my hierarchy:

Here is an image of how Qlikview views the data:

Here is an image of the error with the QUALIFY *

Any assistance is welcome. Thanks!

Re: Hierarchies and Synthetic Views

cesaraccardi — Fri, 20 Jul 2012 19:49:03 GMT

Hi, are you droping the table "table1" after the resident load?

Re: Hierarchies and Synthetic Views

Fri, 20 Jul 2012 19:54:11 GMT

Currently, I am not. should I be?

Re: Hierarchies and Synthetic Views

cesaraccardi — Fri, 20 Jul 2012 20:29:13 GMT

Yes, because the data you have in the initial table is already in the hierarchy load, so this creates a synthetic key between this 2 tables.

Just add the following line after the Hierarchy load:

DROP TABLE table1;

Re: Hierarchies and Synthetic Views

Mon, 23 Jul 2012 11:47:38 GMT

Thank you very much.