Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Link table for 3 or more tables

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

2 Replies
Sokkorn
Honored Contributor

Re: Link table for 3 or more tables

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

Re: Link table for 3 or more tables

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

Community Browser