Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link table for 3 or more tables

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 

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

2 Replies
Sokkorn
Master
Master

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

Not applicable
Author

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