topic an Aggr question in QlikView https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632185#M231956 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am stucked in a aggr task, so i really appreciate any help.</P><P></P><P>I have a table like this:&nbsp; Dimension1, Dimension2, ..., DimensionN, Day&nbsp;&nbsp;&nbsp;&nbsp; (Day is a Date field and can be empty), and I am trying to measure the eficiency of the activity, in terms of how many registrations per day you can do the same day. The aim is a table/chart like this, which would mean, for instance, that there are 198 days in which you were able to do 3 registrations in the same day.</P><P></P><P>Actions per day&nbsp;&nbsp;&nbsp;&nbsp; Number of days</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 115</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 198</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53</P><P>etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Thanks.</P><P></P><P>Marc.</P></BODY></HTML> Thu, 29 May 2014 11:05:32 GMT 2014-05-29T11:05:32Z an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632185#M231956 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am stucked in a aggr task, so i really appreciate any help.</P><P></P><P>I have a table like this:&nbsp; Dimension1, Dimension2, ..., DimensionN, Day&nbsp;&nbsp;&nbsp;&nbsp; (Day is a Date field and can be empty), and I am trying to measure the eficiency of the activity, in terms of how many registrations per day you can do the same day. The aim is a table/chart like this, which would mean, for instance, that there are 198 days in which you were able to do 3 registrations in the same day.</P><P></P><P>Actions per day&nbsp;&nbsp;&nbsp;&nbsp; Number of days</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 115</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 198</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 53</P><P>etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>Thanks.</P><P></P><P>Marc.</P></BODY></HTML> Thu, 29 May 2014 11:05:32 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632185#M231956 2014-05-29T11:05:32Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632186#M231957 <HTML><HEAD></HEAD><BODY><P>Could you post a sample qvw?</P></BODY></HTML> Thu, 29 May 2014 11:09:16 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632186#M231957 tresB 2014-05-29T11:09:16Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632187#M231958 <HTML><HEAD></HEAD><BODY><P>Marc,</P><P>See my answers here: <A _jive_internal="true" href="https://community.qlik.com/message/478904#478904">http://community.qlik.com/message/478904#478904</A></P><P></P><P>Regards,</P><P>Michael</P></BODY></HTML> Thu, 29 May 2014 11:10:57 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632187#M231958 Anonymous 2014-05-29T11:10:57Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632188#M231959 <HTML><HEAD></HEAD><BODY><P>Posted.</P></BODY></HTML> Thu, 29 May 2014 11:50:56 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632188#M231959 2014-05-29T11:50:56Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632189#M231960 <HTML><HEAD></HEAD><BODY><P>Qvw is empty(front-end). Reload; save; reupload.</P></BODY></HTML> Thu, 29 May 2014 11:53:07 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632189#M231960 tresB 2014-05-29T11:53:07Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632190#M231961 <HTML><HEAD></HEAD><BODY><P>Thanks Michael, I did it!</P></BODY></HTML> Thu, 29 May 2014 12:14:58 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632190#M231961 2014-05-29T12:14:58Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632191#M231962 <HTML><HEAD></HEAD><BODY><P>Hello, Marc</P><P></P><P>Using your data, I would use this calculated dimension:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">=Aggr(Sum(ContadorVisita), FechaVisita)</SPAN></P><P></P><P>And this expression:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Count({$&lt;ContadorVisita = {"&gt;0"}&gt;} Distinct FechaVisita)</SPAN></P><P></P><P>I've attached an example QVW.</P><P></P><P>Bruno.</P></BODY></HTML> Thu, 29 May 2014 12:25:55 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632191#M231962 Anonymous 2014-05-29T12:25:55Z Re: an Aggr question https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632192#M231963 <HTML><HEAD></HEAD><BODY><P>Great. Thanks</P></BODY></HTML> Thu, 29 May 2014 12:33:19 GMT https://community.qlik.com/t5/QlikView/an-Aggr-question/m-p/632192#M231963 2014-05-29T12:33:19Z