Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator II
Creator II

Re: Question About Multiple Tables With Same Key Field

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
Highlighted
Specialist III
Specialist III

Re: Question About Multiple Tables With Same Key Field

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

Highlighted
Creator II
Creator II

Re: Question About Multiple Tables With Same Key Field

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

Highlighted
Master III
Master III

Re: Question About Multiple Tables With Same Key Field

Seems polido ,

Got all he needed?

Highlighted
Specialist
Specialist

Re: Question About Multiple Tables With Same Key Field

There is no circular reference in your model.

This seems to look perfect.

Highlighted
Not applicable

Re: Question About Multiple Tables With Same Key Field

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