Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing Growth/decline every month using set analysis

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

5 Replies
sunny_talwar

May be try like this:

Dimension:

MonthName(Date)

Expression:

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

Not applicable
Author

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.

Example1.JPG

I hope this will further assist you to better understand my query.

Kind Regards

Lebo

sunny_talwar

Check this out:

Capture.PNG

Expression:

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

Not applicable
Author

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