topic relationships between multiple tables in QlikView

relationships between multiple tables

Thu, 03 Nov 2011 01:42:40 GMT

I have several tables that are related to each:

Nivel 1

id nivel 1

id compañia

id division

descripcion n1

Nivel 1-2 (relates Nivel 1 with Nivel 2)

id nivel 1

id nivel 2

id division

Nivel 2

id nivel 2

id division

descripcion n2

Nivel 2-3 (relates Nivel 2 with Nivel 3)

id nivel 2

id nivel 3

id division

Nivel 3

id nivel 3

id division

descripcion n3

need to relate everything to another table

Table Presupuest

id compañia

id division

id nivel 1

id nivel 2

id nivel 3

debito

credito

I intet to the relationship in different ways but not working as it should,

please help

relationships between multiple tables

Fri, 04 Nov 2011 16:32:16 GMT

tienes un ejemplo en excel/csv, de tu información que puedas postear?

Re: relationships between multiple tables

Fri, 07 Feb 2014 14:11:46 GMT

I have the same question.

EDIT: This is what we are looking for: Joins and Lookups

Re: relationships between multiple tables

chiru_thota — Fri, 07 Feb 2014 14:52:50 GMT

The main issue here is synthetic keys.You can try two way here

(1) Concatenate all the tables.It will work fine

(2) Rename columns which you think not common between tables.

(3) You can concatenate the columns and come up with composite key to have relation ship.

Thanks,

Chiru