topic Re: Show Active Users by month with type 2 table? in QlikView

Show Active Users by month with type 2 table?

natebrunner — Wed, 10 Dec 2014 17:34:02 GMT

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.

Re: Show Active Users by month with type 2 table?

Anonymous — Wed, 10 Dec 2014 17:36:30 GMT

Sounds like you need the IntervalMatch function.

IntervalMatch

Re: Show Active Users by month with type 2 table?

natebrunner — Wed, 10 Dec 2014 17:40:22 GMT

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.

Re: Show Active Users by month with type 2 table?

Anonymous — Wed, 10 Dec 2014 17:51:07 GMT

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.