Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding IntervalMatch function for slowly changing dimensions

Hello Friends,

Kindly let me know the solutions for the interval match issue below. Actually I have 4 tables,

SalesOrderHeader:

SQL SELECT

    OrderDate,

    TerritoryID,

SalesOrderID

FROM SalesOrderHeader;

SalesTerritoryHistory:

SQL SELECT BusinessEntityID as EmployeeBusinessEntityID,

    EndDate,

    StartDate,

    TerritoryID

FROM SalesTerritoryHistory;

Employee:

SQL SELECT

    EmployeeBusinessEntityID,

    EndDate as Employee_EndDate,

    FirstName,

    StartDate as Employee_StartDate

   

FROM Employee;

SalesOrderDetail:--This is my transaction table

SQL SELECT

     OrderQty,

    ProductID,

    SalesOrderDetailID,

    SalesOrderID,

      UnitPrice,

    UnitPriceDiscount

FROM SalesOrderDetail;

I tried creating interval match function to link the Orderdate in SalesOrderHeader with intervals in SalesTerritoryHistory but it is not working as expected, I need to show the Sales metrics of employees, kindly let me know your solutions.I have attached the datamodel for your reference.

Thanks so much!

Best,

Kiru

1 Reply
Not applicable
Author

Hi,

Please check the article that HIC  wrote about this.

IntervalMatch and Slowly Changing Dimensions

Cheers

Prasan