topic Re: Help with Accumulation of New Distinct Daily Values in QlikView

Help with Accumulation of New Distinct Daily Values

datagrrl — Fri, 15 Nov 2024 23:57:33 GMT

In this example User 4 should count on Day 1, User 1 on day 2, User 2 and 5 on day 3 and user 3 on day 4.

I would prefer this to accumulate for each month. At the end of the month the total should be the total # of distinct NEW users (Not the total of distinct daily users, that would be too high)

Date	NewUsers	CummNewUsers
1/1/2020	1	1
1/2/2020	1	2
1/3/2020	2	4
1/4/2020	1	5
1/5/2020	0	5

I am attaching my dummy data and my example. Any help is appreciated. I am hitting a wall on this one.

Re: Help with Accumulation of New Distinct Daily Values

sunny_talwar — Thu, 17 Sep 2020 18:03:45 GMT

Try this

RangeSum(Above(Sum(Aggr(If(UserID <> Above(TOTAL UserID), 1, 0), UserID, (Date, (NUMERIC)))), 0, RowNo()))

Re: Help with Accumulation of New Distinct Daily Values

datagrrl — Thu, 17 Sep 2020 18:14:43 GMT

Thanks so much. I thought Rangesum might get me there, but I wasn't setting it up correctly.