topic Re: What is Wrong? in QlikView

What is Wrong?

Wed, 25 Nov 2020 16:16:04 GMT

whats wrong in this data model?

Is it correct that there is a syntactic key?

Re: What is Wrong?

oknotsen — Thu, 09 Feb 2017 11:32:31 GMT

Yes, you have a synthetic key.

The top 3 tables have more than 1 field in common, so you get a synthetic key.

Re: What is Wrong?

Michiel_QV_Fan — Thu, 09 Feb 2017 11:35:31 GMT

More information here: Synthetic Keys by hic

Re: What is Wrong?

Peter_Cammaert — Thu, 09 Feb 2017 12:25:04 GMT

If you want to do away with the synthetic keys, create a complex key that concatenates the vlues from the three shared fields in a single (new) key field and drop the base fields from every table except the one containing the largest number of shared values (the superset). In case there is no superset table, you may need to create a LinkTable to make connections to the other tables work as expected. Otherwise you'll get unwanted filtering because of selections in tables with value subsets < 100%

Or - and this is usually better for performance - .put all Ventas, NotasDeCredito & Devoluciones in a single table and leave the key fields as they are. Add an identifier field that contains one of three possible strings, to tell you what type of row your are looking at.

Re: What is Wrong?

buzzy996 — Thu, 09 Feb 2017 12:43:01 GMT

if ur getting the expected values on ur reports with this data model then there is no problem with this synthetic key(because ur having only one key in ur model)

if u have some data issues, u need to redefine the model like Peter suggested by creating complex key or by creating separate table for all key fields and map each individual keys with other tables.

Re: What is Wrong?

Fri, 10 Feb 2017 08:37:38 GMT

i did this:

what do you think?

Re: What is Wrong?

Anil_Babu_Samineni — Fri, 10 Feb 2017 10:03:40 GMT

It's good for view