topic Last ---- in QlikView https://community.qlik.com/t5/QlikView/Last/m-p/591460#M1113116 <HTML><HEAD></HEAD><BODY><P>Hi to all!</P><P></P><P></P><P>I have a chart and my dimension is time(minute) and the expression is count of each minute...I would like to show the last 10 minutes customer count....however, I havent edited time dimension for last 10 minutes...how can I do it?&nbsp;&nbsp; I have attached a sample data set </P><P></P><P></P><P>Thanks for help me out.</P></BODY></HTML> Mon, 03 Mar 2014 12:15:41 GMT 2014-03-03T12:15:41Z Last ---- https://community.qlik.com/t5/QlikView/Last/m-p/591460#M1113116 <HTML><HEAD></HEAD><BODY><P>Hi to all!</P><P></P><P></P><P>I have a chart and my dimension is time(minute) and the expression is count of each minute...I would like to show the last 10 minutes customer count....however, I havent edited time dimension for last 10 minutes...how can I do it?&nbsp;&nbsp; I have attached a sample data set </P><P></P><P></P><P>Thanks for help me out.</P></BODY></HTML> Mon, 03 Mar 2014 12:15:41 GMT https://community.qlik.com/t5/QlikView/Last/m-p/591460#M1113116 2014-03-03T12:15:41Z Re: Last ---- https://community.qlik.com/t5/QlikView/Last/m-p/591461#M1113117 <HTML><HEAD></HEAD><BODY><P>=COUNT({&lt;Minute = {'&lt;=10:00'}&gt;}Location)</P><P>or </P><P>=SUM({&lt;Minute = {'&lt;=10:00'}&gt;}Count)</P><P>or</P><P>=COUNT({&lt;Minute = {'&lt;=10:00'}&gt;}Count)</P></BODY></HTML> Mon, 03 Mar 2014 12:24:48 GMT https://community.qlik.com/t5/QlikView/Last/m-p/591461#M1113117 MK_QSL 2014-03-03T12:24:48Z Re: Last ---- https://community.qlik.com/t5/QlikView/Last/m-p/591462#M1113118 <HTML><HEAD></HEAD><BODY><P>Simply write this on expression side</P><P>Count(TOTAL if(Minute&lt;='10:00',Count))</P></BODY></HTML> Mon, 03 Mar 2014 12:26:44 GMT https://community.qlik.com/t5/QlikView/Last/m-p/591462#M1113118 er_mohit 2014-03-03T12:26:44Z