topic Question About Multiple Tables With Same Key Field in QlikView

Question About Multiple Tables With Same Key Field

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone, I'm new to QlikView and I have a question that I hope it's going to be easy to answer.

So, I've created a new file and all my tables fields are about: year, quantity and percentage. (I've got these excel files from Statistics Websites.)

Now, my concern is: Every table is associating to every other by the field "year", creating a circular reference, as you can see in the picture attached. I believe this procedure is far from the Best Practices so I'm seeking a workaround to this situation. Can you guys help me?

Thanks in advance.

Best regards,

João Polido

Re: Question About Multiple Tables With Same Key Field

Anonymous — Wed, 15 Jun 2016 07:11:34 GMT

Hi João,

You can do it like this:

ES_Area:

LOAD

Ano,

Ano as Year_Gender,

Ano as Year_Private,

TotalArea,

Educacao,

ArtesHumanid,

CienciasSociai,

CienciasMate,

EngenhariaIn,

Agricultura,

SadudeProtecc,

Sercivios

FROM...

;

ES_Sexo:

LOAD

Ano as Year_Gender,

TotalSexo,

Masculino,

Femenino

FROM ...;

ES_Privado:

LOAD

Ano as Year_Private,

TaxaPrivado

FROM...;

Regards!!

Re: Question About Multiple Tables With Same Key Field

pho3nix90 — Wed, 15 Jun 2016 08:26:26 GMT

Hi João,

What you are seeing is not a circular reference but a start schema and is perfectly acceptable.

Below are references, images sourced from Qlikview Tutorial

This is a circular reference, and should ALWAYS be fixed

This is perfect

However, that being said. Without understanding what data each contains (can't understand the language in the schema) it might or might not be the correct KEY. If the only proper key between all 3 tables are date, then use it. However, if you need to use additional keys you will have to concatenate the fields and create a proper key.

Re: Question About Multiple Tables With Same Key Field

sujeetsingh — Wed, 15 Jun 2016 08:35:38 GMT

Seems polido ,

Got all he needed?

Re: Question About Multiple Tables With Same Key Field

varshavig12 — Wed, 15 Jun 2016 08:37:07 GMT

There is no circular reference in your model.

This seems to look perfect.

Re: Question About Multiple Tables With Same Key Field

Wed, 15 Jun 2016 10:57:14 GMT

Thanks to all of you who have lost a little of your time to answer me. Now I understand that my model is correct and I'll be renaming future fields if necessary, like manucamon‌ told me.

Cheers