topic Re: Aggr doesn't work with computer dimensions, so how do I do aggr(count(x), Date(timestamp))? in QlikView

Aggr doesn't work with computed dimensions, so how do I do aggr(count(x), Date(timestamp))?

Thu, 19 Jun 2014 08:45:13 GMT

Let's say, I need to find the avg number of distinct buyers per day so it should be, theoretically, something like this:

avg( aggr( count(distinct buyer_id), date(purchase_time) ) )

but this doesn't work because aggr() can't take computed dimension, I.E - date(purchase_timestamp).

What is the best solution for this?

Thanks in advance.

mdmukramali — Thu, 19 Jun 2014 08:48:34 GMT

Dear,

can you try to create a field in the script level.

date(purchase_time) as Purchase_Date

then

avg( aggr( count(distinct buyer_id), Purchase_Date) )

hope it will work.

Thanks,

Mukram

Thu, 19 Jun 2014 10:29:25 GMT

I was hoping to find a solution that does not involve without having to redefine the model but I guess there is none.

Thanks!