topic Re: Data Modeling - Association issue in QlikView

Data Modeling - Association issue

Anonymous — Fri, 28 Aug 2015 03:20:31 GMT

Hi Community,

I have a data model where I'm going to make association between listed tables, each tables has there own individual fields such as mentioned below,

U_Table:

Load %UKey,

Country,

Unit

from utable.xlsx;

U_Fcts_LinkTable:

Load %ClndrKey,

%UKey;

U_Clndr_Table:

Load %ClndrKey,

Month,

Date,

Year

from calender.xlsx;

How to associate listed below table with given above tables, please note when I select country/year or month, values must be reflect or change in whole dashboard graph.

NewTable:

Load Year,

Month,

Country

from new_table.xlsx;

regards,

eng

Re: Data Modeling - Association issue

jagan — Fri, 28 Aug 2015 03:56:38 GMT

Hi,

Already there is Year, Month and Date field in U_Clndr_Table table, then why you are adding another table? In case if you need additional table on what basis this new table should be joined to the existing tables? Which table and which column you want to join with?

Regards,

jagan.

Re: Data Modeling - Association issue

Anonymous — Fri, 28 Aug 2015 04:44:23 GMT

Hi Jagan,

I'm trying to associate NewTable with U_Table on the basis of Country Field.

After that I want to associate NewTable with U_Clndr_Table on the basis of Year/Month.

regards,

eng

Re: Data Modeling - Association issue

Fri, 28 Aug 2015 04:59:51 GMT

Hi Eng,

Try the below one, Hope it solve your issue

U_Table:

Load %UKey,

Country,

Unit

from utable.xlsx;

U_Fcts_LinkTable:

Load %ClndrKey,

%UKey;

U_Clndr_Table:

Load %ClndrKey,

Month,

Date,

Year

from calender.xlsx;

Concatenate

NewTable:

Load Year,

Month,

// Country (Comment this field)

from new_table.xlsx

where not exists(Year) and Not Exists(Month);

Cheers

Kalyan R

Re: Data Modeling - Association issue

sasiparupudi1 — Fri, 28 Aug 2015 20:02:20 GMT

Try Like this

U_Table:

Load * inline

[%UKey, Country,Unit];

U_Fcts_LinkTable:

Load * inline

[

%ClndrKey,%UKey

];

U_Clndr_Table:

Load * inline

[%ClndrKey,Month,Date,Year

];

NoConcatenate

NewTable:

Load * inline

[ Year1,Month1,Country

];