Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

natebrunner
New Contributor II

Show Active Users by month with type 2 table?

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.

Tags (2)
3 Replies

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

Sounds like you need the IntervalMatch function.

IntervalMatch

natebrunner
New Contributor II

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

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?

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.

Community Browser