topic Re: Max record date in QlikView https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681745#M542199 <HTML><HEAD></HEAD><BODY><P>Thank you very much.</P></BODY></HTML> Mon, 16 Jun 2014 07:57:47 GMT amiroh81 2014-06-16T07:57:47Z Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681740#M542194 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a table with multiple measures and column timestemp. </P><P>The data appear in intervals of 10 minutes. </P><P>I want to display only the values ​​listed in the table with the last interval. </P><P></P><P></P><P>I tried to build the table and chart style as well as table box and I could not do this with the command max (record_date (</P><P>Can anyone help me please? </P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Sun, 15 Jun 2014 13:44:43 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681740#M542194 amiroh81 2014-06-15T13:44:43Z Re: Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681741#M542195 <HTML><HEAD></HEAD><BODY><P>I'm not sure what you want - but try<BR />max(<STRONG>total</STRONG> record_date)<BR />or<BR />max (<STRONG>all</STRONG> record_date)</P></BODY></HTML> Sun, 15 Jun 2014 13:57:11 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681741#M542195 Anonymous 2014-06-15T13:57:11Z Re: Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681742#M542196 <HTML><HEAD></HEAD><BODY><P>Aggr(Max(TOTAL Record_Date),YourFieldName)</P></BODY></HTML> Sun, 15 Jun 2014 14:00:10 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681742#M542196 MK_QSL 2014-06-15T14:00:10Z Re: Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681743#M542197 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>max(total record_date) work!</P><P></P><P>can you Explain me what is the total command please ?</P><P></P><P>thank you very much</P></BODY></HTML> Sun, 15 Jun 2014 14:01:16 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681743#M542197 amiroh81 2014-06-15T14:01:16Z Re: Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681744#M542198 <HTML><HEAD></HEAD><BODY><P>The "total" qualifier in this case tells to disregard chart dimensions.&nbsp; If you use "all" - it disregards dimensions and selections.<BR />(See "help")</P></BODY></HTML> Sun, 15 Jun 2014 14:07:25 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681744#M542198 Anonymous 2014-06-15T14:07:25Z Re: Max record date https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681745#M542199 <HTML><HEAD></HEAD><BODY><P>Thank you very much.</P></BODY></HTML> Mon, 16 Jun 2014 07:57:47 GMT https://community.qlik.com/t5/QlikView/Max-record-date/m-p/681745#M542199 amiroh81 2014-06-16T07:57:47Z