topic Re: Set Analysis - Calculating Cumulative Unique User Count in QlikView

Set Analysis - Calculating Cumulative Unique User Count

Thu, 21 Nov 2013 16:36:13 GMT

Hello,

I have the following table,

Order Date,

OrderId

UserId

I would like to see in a table for each day, number of distinct users ordered for the last 365 days.

i.e.

for 01.01.2013 - count of distinct users ordered between 01.01.2012 and 01.01.2013

for 02.01.2013 - count of distinct users ordered between 02.01.2012 and 02.01.2013

and so on.

so i need a table with daily based date dimension and an expression with count of distinct users.

Thanks in advance.

Fri, 22 Nov 2013 06:41:32 GMT

Hi,

PFA

Fri, 22 Nov 2013 07:51:08 GMT

Hi,

You just calculated the daily unique customer count. I want to calculate a time range of 365 for each day.

Fri, 22 Nov 2013 09:02:44 GMT

Hi,

Give one sample for better understanding of your requirement