topic Re: $Syn1 Table in QlikView

$Syn1 Table

Sun, 28 Jul 2013 19:20:22 GMT

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

Re: $Syn1 Table

Mon, 29 Jul 2013 06:41:05 GMT

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.

Re: $Syn1 Table

kaushiknsolanki — Mon, 29 Jul 2013 06:45:06 GMT

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

Re: $Syn1 Table

ariel_klien — Mon, 29 Jul 2013 06:46:23 GMT

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.

Ariel