topic Cumulative new contacts in graph in QlikView

Cumulative new contacts in graph

Anonymous — Mon, 29 Aug 2011 13:43:30 GMT

I need to make a graph which shows cumulative count of new contacts over time.

For exampe:

customer A contacts 3 times in Jan

customer B contacts 4 times in Jan

customer A contacts 3 times in Feb

customer C contacts 1 times in Feb

customer A,B and C contacts 3 times in Mar

customer D contacts 1 times in Apr

The graph shoud show

- 2 cumulative contacts in Jan

- 3 cumulative contacts in Feb

- 3 cumulative contacts in Mar

- 4 cumulative contacts in Apr

See the attached example.

Looks like quite common situation. I tried combinations of aggr and above functions, but with no luck. Hopefully someone can give me a hand.

Best regards Pertti

Cumulative new contacts in graph

SunilChauhan — Mon, 29 Aug 2011 13:54:21 GMT

if i am not wrong cumulative means it will include old data also

ex : if i have 2 customers in jan and 3 in feb then it will show 2 in jan and 5 in Feb using accumlation.

if i am wrong please correct me?

Cumulative new contacts in graph

Anonymous — Tue, 30 Aug 2011 06:16:27 GMT

Thanks for Your quick answer. In this case I cumulate only new contacts. If customer A and B contacts once or more often in Jan, the cumulative number of new customers is 2. If customer A contacts in Feb, the cumulative number of new contacts in the time period is still 2. No new customers.

The solution is found by my colleague. I use expression: Sum(aggr(Count( distinct Customer), Customer)).