topic Re: Data Modeling problem in QlikView

Data Modeling problem

indiana256 — Sat, 16 Nov 2024 20:36:51 GMT

Hi everyone,

this is my Data Model. The data table has several relationships. Is there any way to split "Cta" and "Fecha" key fields into two different? I need them to be independant.

Hope you can help me

Thanks in advance

Re: Data Modeling problem

felipedl — Fri, 21 Jun 2019 20:36:50 GMT

Make a composite key of the Cta and Fecha fields and comment them on "Presup*" tables.

Only leave the separate fields on the datos tables, so it can link up to the calendar and Cuentas tables.

Another thing you could do, since they're common fields on multiple tables, is to join them so that all "Presup*" tables are merged into one single table.

Datawise they'll be independent, since the combination of both fields will occur on specific dates (i'm assuming that's what "datos" means), giving you independency on the main table.

Re: Data Modeling problem

Brett_Bleess — Mon, 22 Jul 2019 18:21:24 GMT

Here is another Design Blog post that may be useful to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett