Hierarchies and Synthetic Views

[#1]

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!

[cesaraccardi]

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

[#3]

Currently, I am not. should I be?

[cesaraccardi · Accepted solution]

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;

[#5]

Thank you very much.