topic Interval Match Not quite working!! in QlikView

Interval Match Not quite working!!

Tue, 30 Apr 2013 16:24:33 GMT

Hi All

I have, mostly using info from the community managed to build a table using Interval Match I do get a table but for some reason it is called TempDateIM-1 and is a syn table...is this correct?

If not could you please advise a solution for what I am missing?

thanks in advance.


WeeklyCost:
LOAD  dteFromDate,
dteToDate,
intEnrolId,
intPriceItemId,
curBasic,
InvoiceLine.ItemDays,
InvoiceLine.DailyValue

RESIDENT InvoiceLine;
//Keeps minimum and maximum Date value from Invoice Dates Invoice Line table
MinMaxIM:
LOAD
 Min(dteFromDate) as MinDateIM,
 Max(dteToDate) as MaxDateIM
 
 
RESIDENT  WeeklyCost;
LET vMinDateIM = num(makedate(2009,1,1));
//LET vMinDateIM = Num(Peek('MinDateIM', 0, 'MinMaxIM')); 
LET vMaxDateIM = Num(Peek('MaxDateIM', 0, 'MinMaxIM'));
LET vToday = $(vMaxDateIM);

//*************** Temporary Calendar *************
//Generates a single table with one field containing all existing dates between MinDate and MaxDate
TempCalIM:
LOAD 
 Date($(vMinDateIM) + rowno() - 1) AS TempDateIM
AUTOGENERATE 
 $(vMaxDateIM) - $(vMinDateIM) + 1;
DROP TABLE MinMaxIM;
IntervalMatch (TempDateIM) LOAD dteFromDate, dteToDate RESIDENT WeeklyCost;
DROP TABLE TempCalIM;

Re: Interval Match Not quite working!!

Gysbert_Wassenaar — Tue, 30 Apr 2013 18:07:18 GMT

You didn't specify a name for the intervalmatch table so it gets the name of the previous one with -1 appended.

TabelNameHere:

IntervalMatch (TempDateIM) LOAD ...etc

You get a syn table. That's correct and not a problem. Read this blog post for an explanation.

Re: Interval Match Not quite working!!

Wed, 01 May 2013 09:34:55 GMT

Hi GysbertThanks for your help novice error I guess!!

One last issue is that I now have 2 tables with no link other than dates, how do I create a single table for the dates and the orginal data from WeeklyCost into one table?

is that possible?

Thanks

David