topic Re: sample_datamodel in QlikView

sample_datamodel

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Help me to create Link table at this situation to resolve all syn keys.

This is my data model in my actual data so am attaching only dummy data(which contains only fields and has no data).

Here how do we follow to resolve syn keys without renaming field names??

PFB for your reference!!!

Kindly suggest.

Any help will be appreciated.

Re: sample_datamodel

antonybi — Tue, 05 Dec 2017 19:37:03 GMT

Kindly check below sample application and suggest.

Is this data model gives us accurate results???

please suggest if anything wrong. !

Re: sample_datamodel

MK9885 — Tue, 05 Dec 2017 20:18:00 GMT

With out sample data it would be hard to assume what join can be made.

Names of the field can be changed, HC can be Master table sine it has all the fields from other tables.

ID can be Primary key to link HC<>NS and maybe Client can be a key to link to TC<>HC table.

But without data it can be tricky.

Re: sample_datamodel

vishsaggi — Tue, 05 Dec 2017 21:21:26 GMT

This looks good to me. Whats the issue you are facing?

Re: sample_datamodel

antonybi — Wed, 06 Dec 2017 05:14:39 GMT

Yes I agreed. But here I just wanted to know the logic whether it was correct or wrong.

I have created too many reports with the first data model.

Afterwards, I have to resolve these syn keys by linking with link table or etc.

Link table which I have created (shown in the 2nd snapshot) I wanted to now does it(link table) cause any incorrectness of the data.

Kindly suggest.

Re: sample_datamodel

vishsaggi — Wed, 06 Dec 2017 12:56:27 GMT

It should work good. However, you can also concatenate tables if they hold similar field names and no. of fields or use forced concatenation where possible. So which ever approach should work fine and also check your Information density and Subset ration for your table fields between all the linked tables.

Re: sample_datamodel

MK9885 — Wed, 06 Dec 2017 14:20:23 GMT

To test if the data model is correct, do either counts or sum, depending on what you have with small data set?