topic Max daily performace over a time peroid in QlikView https://community.qlik.com/t5/QlikView/Max-daily-performace-over-a-time-peroid/m-p/209491#M64451 <HTML><HEAD></HEAD><BODY><P>Hi there, the expression should be similar to the following:</P><P>max(aggr( count(distinct [Lead ID]), Date))</P><P>Regards</P></BODY></HTML> Mon, 20 Sep 2010 15:37:27 GMT 2010-09-20T15:37:27Z Max daily performace over a time peroid https://community.qlik.com/t5/QlikView/Max-daily-performace-over-a-time-peroid/m-p/209490#M64450 <HTML><HEAD></HEAD><BODY><P>Good afternoon</P><P>I'm looking to create a simple stright table which shows number of leads generated with in given time peroid (selectable list boxes), the average number of leads created and the maxiumim number of leads generated with in a single day.</P><P>The first two parts were easy, how ever im stuggling to create a forumla which calculates the maximum number of leads produced in one day. Can anyone help?</P><P>Cheers</P><P>Shaun</P></BODY></HTML> Mon, 20 Sep 2010 15:12:09 GMT https://community.qlik.com/t5/QlikView/Max-daily-performace-over-a-time-peroid/m-p/209490#M64450 2010-09-20T15:12:09Z Max daily performace over a time peroid https://community.qlik.com/t5/QlikView/Max-daily-performace-over-a-time-peroid/m-p/209491#M64451 <HTML><HEAD></HEAD><BODY><P>Hi there, the expression should be similar to the following:</P><P>max(aggr( count(distinct [Lead ID]), Date))</P><P>Regards</P></BODY></HTML> Mon, 20 Sep 2010 15:37:27 GMT https://community.qlik.com/t5/QlikView/Max-daily-performace-over-a-time-peroid/m-p/209491#M64451 2010-09-20T15:37:27Z