Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question About Multiple Tables With Same Key Field

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

1 Solution

Accepted Solutions
pho3nix90
Creator II
Creator II

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

3_cr_data_model.JPG

This is perfect

5_cr_data_model_rectified.JPG

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.

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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
Creator II
Creator II

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

3_cr_data_model.JPG

This is perfect

5_cr_data_model_rectified.JPG

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
Master III
Master III

Seems polido ,

Got all he needed?

varshavig12
Specialist
Specialist

There is no circular reference in your model.

This seems to look perfect.

Not applicable
Author

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