topic Data model issue in QlikView

Data model issue

deepakqlikview_123 — Wed, 11 Jan 2017 14:18:29 GMT

Hi All,

PFA.

I am not able to associate the table AR_VarianceSummary and BU_HIER_D_Movement.

Can you please suggest how should i handle it Moreover plz suggest how should i avoid synthetic keys

Re: Data model issue

vishsaggi — Wed, 11 Jan 2017 14:43:16 GMT

It says access denied when trying to open your document. Do you have section access in this?

Re: Data model issue

enriquem — Wed, 11 Jan 2017 14:57:24 GMT

We can't open your file, reupload it!!

Re: Data model issue

deepakqlikview_123 — Thu, 12 Jan 2017 05:40:37 GMT

Hi All,

PFA.

I have removed section access.

thanks

Re: Data model issue

deepakqlikview_123 — Thu, 12 Jan 2017 07:23:43 GMT

Experts,

Can you please suggest on this

Thanks

Re: Data model issue

enriquem — Thu, 12 Jan 2017 09:12:24 GMT

Hi,

I will suggest you to use the "Qualify" and "Unqualify" keyword to put a prefix in the AR_VarianceSummary fields and in the another tables that create you the synthetic keys.

Qualify *;

// your load table code

Unqualify *;

Here I put you some help about the qualify, because if you don't wanted to rename some field you must put just the field to rename in the qualify.https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Qualify.htm

And to the question in this thread, I must said you that the 2 tables are relationship by the Comp_HierID.

Regards.

Re: Data model issue

deepakqlikview_123 — Thu, 12 Jan 2017 09:35:59 GMT

But after using that results has been changed. It is giving wrong results.

Thanks

Re: Data model issue

enriquem — Thu, 12 Jan 2017 09:48:49 GMT

This can be because you don't create a good relationship of your data. You must put the same name to the field that you wanted like a relationship.

I don't know the proposal of your data, and how you wanted to mine your data, so I can't help you to build your data model.