Set Analysis Problem

[#1]

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.

[#2]

Hi Anil,

I think this is a rather complex issue but you may find the route to the answer in the following document:

http://community.qlik.com/docs/DOC-4252

Regards,

Gerrit

[#3]

Thanks but i need unique customer count. Accumulative sums are not helping me here.

[#4]

Anil,

What I see is that you are facing more or less the same challenge with regards to the rollig period approach.

So it is not the accumulative sum but the way you can calculate rolling periods I thought might be of help.

Regards,

Gerrit