$Syn1 Table

[#1]

Hi all

I am new to QlikView and and working on building a simple dashboard.  I have set up different tables of data which all either include Period and Year or Month or Year.  I have made Month, Year and Period primary keys.  I have attached a copy of my table viewer - when I had only loaded the passenger injuries and sickness tables (along with the year, month and period tables) everything linked nicely, however when I then added the failures table it created the $Syn1 table with period and year in.

Can anyone let me know what I am doing wrong?

Many thanks

[#2]

Can u attach the table viewer before adding failures table?

However we can refuse the synthetic key through concatenate the two fields like below.

Pk_Year&'#'&Pk_Period as Key_YearPeriod

do Like above in  all tables.

[kaushiknsolanki]

Hi,

     Use below code to avoid the Syn Key from your data model.

Sickness:
Load Sickness*, PK_YEAR&'-'&PK_PERIOD as %SicknessKey
From Sickness;

Failures:
Load Failures*, PK_YEAR&'-'&PK_PERIOD as %FailureKey
From Failures;

Passengers_Inquiries:
Load  Passengers_Inquiries*, PK_YEAR&'-'&PK_PERIOD as %PIKey
From Passengers_Inquiries;

Link_Table;
Load PK_YEAR,PK_MONTH, PK_YEAR&'-'&PK_PERIOD as %SicknessKey
From Sickness;

Concatenate

Load PK_YEAR,PK_MONTH, PK_YEAR&'-'&PK_PERIOD as %FailureKey
From Failures;

Concatenate

Load  PK_YEAR,PK_MONTH, PK_YEAR&'-'&PK_PERIOD as %PIKey
From Passengers_Inquiries;

     Where * means all the other fields.

     Instead of star kindly give the other field names.

Regards,

Kaushik Solanki

[ariel_klien]

Hi

you need to make a key:

SICKNESS:

Load PK_Year,

        PK_Period,

        PK_Year&'-'&PK_Period as Key,

        Sikness....,

       ....

From ....

FAILURES:

Load   PK_Year&'-'&PK_Period as Key,

          Failures....,

          ....

From ....

// in the Failures Table you do not load the fields PK_Year,PK_Period

Hope this will help you.

BR

Ariel