QlikView App Dev

[natebrunner]

I am trying to create a bar chart that shows Active Users by month. The data I have is in a type 2 dimension with Start and End Dates, with the most current row having a null End Date.

What would be the most efficient way to try and show active users by month over a years time, or rolling 12 months so that I don't have to try and hard code dates into the logic or count up the users with some massive if statement.

Thanks in advance for help.

[Anonymous]

Sounds like you need the IntervalMatch function.

IntervalMatch

[natebrunner]

I thought about that but I guess I'm not completely sure how to apply it or what to use for the expressions and dimensions in the chart.

[Anonymous]

Have a read of Henric's blog post IntervalMatch and give it a go. 

If you work with just a small sample of test data, then if you get stuck you can post a question on this forum attaching your qvw.