Weekly summaries?

Tue, 10 Dec 2013 21:16:22 GMT

Hi,

I need to reproduce the following Excel table:

Date	Total Number of Registered Users	Number logging in per week	Usage as % of Total
6-Dec-13	3523	118	3.35%
29-Nov	3532	5	0.14%
22-Nov	3521	8	0.23%
15-Nov	3517	6	0.17%
8-Nov	3516	26	0.74%
1-Nov	3516	28	0.80%
25-Oct	3516	13	0.37%
18-Oct	3,515	24	0.70%

In Excel, this is simple - I set the date in the first row, and then the first column is simply A1-7,A1-14, etc.

When I do my sums, it's simply (e.g. for B1) COUNTIF(joindate<=A1,username), and copy it down.

How would I do this in QV? I'm sure it's simple, but I can't see it.

Thanks!

topic Weekly summaries? in QlikView