Discussion Board for collaboration on QlikView Scripting.
Please assist with showing Growth/decline of i.e.membership every month using set analysis.
I only want to start counting the number of new members when their joindate is within the required month.
i.e. Policy 1 - Joindate 01/01/2015
Policy 2 - Joindate 01/02/2015
Policy 3 - Joindate 01/02/2015
Policy 4 - Joindate 01/03/2015
Therefore, for reporting purposes the results should be:
Jan 2015 - 1
Feb 2015 - 3
Mar 2015 - 4
New user to Qlikview
May be try like this:
RangeSum(Above(Count(Policy), 0, RowNo()))
Hi Sunny T,
Thanks for your response, though the answer you gave me is accumulative.
I need the result to only start counting the policies per after their join date has elapsed.
Further Clarity is as per attachment.
I hope this will further assist you to better understand my query.
Check this out:
RangeSum(Before(Count([Policy No]), 0, ColumnNo()))
Thank you very much Sunny T.
It really worked wonders.
Big Ups to you
If you got what you wanted, I would ask you to close this thread by marking correct and any helpful answers.
Qlik Community Tip: Marking Replies as Correct or Helpful