Question About Multiple Tables With Same Key Field

[#1]

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

[Anonymous]

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!!

[pho3nix90 · Accepted solution]

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.

[sujeetsingh]

Seems polido ,

Got all he needed?

[varshavig12]

There is no circular reference in your model.

This seems to look perfect.

[#6]

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