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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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