Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Showing Growth/decline every month using set analysis

May be try like this:

Dimension:

MonthName(Date)

Expression:

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

Not applicable

Re: Showing Growth/decline every month using set analysis

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

Re: Showing Growth/decline every month using set analysis

Check this out:

Capture.PNG

Expression:

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

Not applicable

Re: Showing Growth/decline every month using set analysis

Thank you very much Sunny T.

It really worked wonders.

Big Ups to you

Re: Showing Growth/decline every month using set analysis

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

Community Browser