Showing Growth/decline every month using set analysis

[#1]

Good day,

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

Regards

New user to Qlikview

[sunny_talwar]

May be try like this:

Dimension:

MonthName(Date)

Expression:

RangeSum(Above(Count(Policy), 0, RowNo()))

[#3]

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.

Kind Regards

Lebo

[sunny_talwar]

Check this out:

Expression:

RangeSum(Before(Count([Policy No]), 0, ColumnNo()))

[#5]

Thank you very much Sunny T.

It really worked wonders.

Big Ups to you

[sunny_talwar]

Awesome.

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