topic Point in time Reporting - New / Lost / Total Customer in QlikView

Point in time Reporting - New / Lost / Total Customer

Fri, 25 Oct 2013 11:23:33 GMT

hi i have built an application to assist me with the follow up.

however i am still struggling with these three key figures.

i would like the key figures to represent the respective years in a table.

For example.

Year New Lost Total

2012 10 0 45

2013 20 5 60

i have attached my document with the conditions and my calculations, but cannot seem to get it right.

any help is greatly appreciated.

Best

Brad

Re: Point in time Reporting - New / Lost / Total Customer

Gysbert_Wassenaar — Fri, 25 Oct 2013 18:47:43 GMT

I can't make heads or tails of the data in your document. You're requirement sounds a lot like an earlier question for which I created an example (see attachment).

Re: Point in time Reporting - New / Lost / Total Customer

Fri, 25 Oct 2013 19:22:07 GMT

HI.

thank you for your reply.

your example is much the basis of what i am looking for.however, if you were to take away the selection property on the month the logic is lost. Any way to have the logic remaining without selecting the month in your example?

i.e

month lost new active reactivated

1 0 0 10 0

2 2 0 10 0

3 3 2 12 0

4 4 1 13 0