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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

intervalmatch crashes

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.

0 Replies