I am pretty new to qlik sense and trying to do the following: In our dance club we have members with admission and release dates assigned to them. Now I want to have a line or bar chart which shows me the number of members per month. Example data looks like this:
Name | Admission | Release
Peter | 01/11/2010 |
Maria | 22/03/2011 | 01/01/2012
Tom | 30/12/2013 |
So for example for June 2011 I would expect the chart to show 2 members (Peter and Maria).
Thank you for the quick reply. It helps a lot but somehow I do not get the while loop working correctly. It seems to loop over the first name only, so I get all months for Peter until today, but Maria and Tom are missing. Is there a typical error I be doing or are more details needed to find a solution?