topic Re: Link table for 3 or more tables in QlikView

Link table for 3 or more tables

Mon, 07 Nov 2011 10:44:16 GMT

Hello everybody,

How can i create link table for 3 or more tables?

I have 3 tables with date field and i need break them in year, month, day and week-day.

Thank you

Re: Link table for 3 or more tables

Sokkorn — Mon, 07 Nov 2011 11:04:56 GMT

Hi,

Try scenario:

[Table1]:
LOAD
    FA1    AS [FA1-FB1],    //Table1 link to Table2 with field [FA1-FB1]
    FA2,
    FA3
FROM ...
[Table2]:
LOAD
    FB1    AS [FA1-FB1],
    FB2    AS [FB2-FC1],    //Table2 link to Table3 with field [FB2-FC1]
    FB3
FROM ...
[Table1]:
LOAD
    FC1    AS [FB2-FC1],
    FC2,
    YEAR(FC2)    AS [Years],
    MONTH(FC2)    AS [Months],
    DAY(FC2)    AS [Days],
    WeekDay(FC2)    AS [WeekDays]
    FC3
FROM ...

Just an idea and hope it help you.

Regards,

Sokkorn

Re: Link table for 3 or more tables

Thu, 26 Sep 2013 06:51:57 GMT

Hope the below blog of Stephen Redmond with detailed information about creating link tables could help you:

http://www.qliktips.com/2011/05/rules-for-creating-keylink-table-in.html