Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

spikenaylor1
New Contributor III

data linking

I have one ms access database for overtime recorded.

one query contains majority of data

one table contains overtime budget for each year.

Struggling to get the two linked

LOAD *,

     MonthName([OvertimeDate]) as Month,

     QuarterName([OvertimeDate]) as Quarter,

     WeekName([OvertimeDate]) as Week,

     Yearname([OvertimeDate]) as Year;

ODBC CONNECT32 TO [MS Access Database;DBQ=E:\Database1.accdb];

SQL Select Company,

    FullName,

    HoursCashed,

    OvertimeDate,

    OvertimeRate1 as overtimerate,

    OvertimeWorked1 as overtimeworked,

    Processes,

    Shift,

    strClassName,

    ToilTaken,

    TotalCost

FROM "E:\Database1.accdb"."qry_AllData";

Concatenate SQL Select FullName,

     OvertimeDate,

    OvertimeWorked2 as overtimeworked,

    OvertimeRate2 as overtimerate

    FROM "E:\Database1.accdb"."qry_AllData";

SQL Select OvertimeYear as Year,

    OvertimeBudget,

    OvertimeBudgetID

FROM "E:\Database1.accdb"."tbl_OvertimeBudget";

The data is sort of linked but shows all values within a list box

ie.

2016 - qry_AllData

2017 - qry_AllData

2016 - tbl_OvertimeBudget

2017 - tbl_OvertimeBudget

How to link these two data sources?

Many thanks for looking

1 Reply
spikenaylor1
New Contributor III

Re: data linking

Could anyone help or point me to the correct resource to try and figure this out please

Many Thanks