topic Re: Showing Growth/decline every month using set analysis in QlikView

Showing Growth/decline every month using set analysis

Thu, 28 Apr 2016 13:44:39 GMT

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 — Thu, 28 Apr 2016 15:47:27 GMT

May be try like this:

Dimension:

MonthName(Date)

Expression:

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

Fri, 29 Apr 2016 12:50:31 GMT

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 — Fri, 29 Apr 2016 18:33:42 GMT

Check this out:

Expression:

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

Fri, 06 May 2016 12:02:42 GMT

Thank you very much Sunny T.

It really worked wonders.

Big Ups to you

sunny_talwar — Fri, 06 May 2016 15:46:49 GMT

Awesome.

If you got what you wanted, I would ask you to close this thread by marking correct and any helpful answers.