topic Re: Aggr in set analysis in QlikView

Aggr in set analysis

Wed, 26 Jun 2013 20:13:09 GMT

count(({$<Date={">=$(=(MonthStart(Max(Date))))<=$((=(Monthend(Max(Date))))"}>}distinct <docname,username,date> sessionid)

i was trying this expressiopn to get the count of the days per user, document and irrespective of no of sessions performed on any given day. Seems like the expression is not working if we can use aggr in set analysis is that some that wrong with my sytax?

Re: Aggr in set analysis

Thu, 27 Jun 2013 11:43:10 GMT

You frogot the total:

count({$<Date={">=$(=MonthStart(Max(Date)))<=$((=Monthend(Max(Date)))"}>} distinct total <docname,username,date> sessionid)

But if you dont have docname,username,date as a demensions in you chart. Then you need to use aggr:

sum(aggr(count({$<Date={">=$(=MonthStart(Max(Date)))<=$((=Monthend(Max(Date)))"}>} distinct sessionid), docname, username, date))

Re: Aggr in set analysis

Thu, 25 Jul 2013 18:23:21 GMT

Hi Alex, in the expressions that you have provided do i need to follow the sequence or doesn't matter when i write the aggr function between docname, username, date and sessionid?

Re: Aggr in set analysis

Fri, 26 Jul 2013 07:33:03 GMT

I dont fully understand your question, but

docname, username, date may be in any order

the first argubent is expression, the others is demensions.