topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Thu, 21 Nov 2013 10:25:24 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.

Thu, 21 Nov 2013 10:41:01 GMT

Hi Anil,

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

Regards,

Gerrit

Thu, 21 Nov 2013 16:13:39 GMT

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

Thu, 21 Nov 2013 16:35:39 GMT

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