intervalmatch crashes

Wed, 25 Jul 2012 09:00:37 GMT

Table has the foll. structure:

aa2:

Load * INLINE

[ ObjID, StartDate, EndDate

OB1, '2012-04-01', '2012-07-25'

OB2, '2011-12-10', '2012-03-15'

OB3, '2012-06-20', '2012-06-25'

OB4, '2012-02-01', '2013-01-01'

];

e.g. A ObjID OB1 has a start date '2012-04-01' and end date '2012-07-25'.

For each month, I want to show the count of ObjID which means this ObjID will be shown for 4 months starting from April, May, June and July.

i have tried generating extra months and used IntervalMatch to fill the missing ObjIDs - May and june but it crashes in case of large number of records.

Can anybody plz. suggest me a solution for this issue?

Thanks.

topic intervalmatch crashes in QlikView

intervalmatch crashes