Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intervalmatch help needed


I need to combine two tables into one to analyze actual demand vs shipped qty but I have not found a good way to do this yet.

Hope somebody could help me with this.

The challenge is that table for actual demand is aggregated by date (timestamp) while shipped qty is aggregated by period with a from - to timestamp.

This shows the intended result:


I have attached the qvd file for this simplified example.

7 Replies

See attached qvw.

talk is cheap, supply exceeds demand
Not applicable

Thanks Gysbert,

The actual data contains many million rows. Do you recommend this solution in this case, or is there a different method to sum(ActualDemandQty) in the script?


Surely you don't intend to show all the millions of rows in a sheet object at the lowest level of detail?

talk is cheap, supply exceeds demand
Not applicable

The table showing the ship qty also contains other information such as forecast for the period.

So what I really want to do is to analyze Forecast vs Actual Demand vs Shipped Qty over different time intervals.

Actual demand I need to get from a different table and this is showing demand per date, not per period.

So I have about 30.000 items and 150 periods per item.

I need to show this data for every item and then I will have to aggregate periods to show e.g. YTD, LY, Quarters etc. and calculate forecast accuracy over the time interval and highlight items with low accuracy.

Ideally (I think..) I would want the sum(actual demand qty) joined into the shipqty table.

Not sure if the explanation helps?


If you want you can join all the data in the script into one table. Or you can create additional summary tables. But I'd start with giving the users options to make selections so they're not confronted with non-performing sheet objects that try to show 30.000 items over 150 periods at the same time.

talk is cheap, supply exceeds demand
Not applicable

I agree.

How would you do it if we were to join all data into one table in the example attached?



Not that I recommend it but, this should do it:


LOAD WarehouseItem,



FROM [ActualDemand.qvd] (qvd);


LOAD WarehouseItem,

    [Shipped Qty],



FROM [ActualDeliveries.qvd] (qvd);



LOAD PeriodFromDate,PeriodToDate,WarehouseItem

Resident Tmp;


LOAD * Resident Tmp;

Drop Table Tmp;

talk is cheap, supply exceeds demand