topic Re: Max Date on Filter Pane in QlikView https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422822#M428986 <HTML><HEAD></HEAD><BODY><P>Have you tried with your field name in place of 'DateField' ?</P></BODY></HTML> Tue, 24 Oct 2017 12:28:13 GMT tresB 2017-10-24T12:28:13Z Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422818#M428982 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a requirement wherein i have a date field containing all the dates from 2016 till present .</P><P>I need to show only <STRONG>Max Date</STRONG> IN Filter pane.</P><P>Please help</P></BODY></HTML> Tue, 24 Oct 2017 12:19:17 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422818#M428982 poojashribanger 2017-10-24T12:19:17Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422819#M428983 <HTML><HEAD></HEAD><BODY><P>You mean in a list box? You can try expression, like: <EM>=Max(<STRONG>Total</STRONG> DateField)</EM></P></BODY></HTML> Tue, 24 Oct 2017 12:23:37 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422819#M428983 tresB 2017-10-24T12:23:37Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422820#M428984 <HTML><HEAD></HEAD><BODY><P>did you tried</P><P><STRONG>=max(DATE_FIELD)</STRONG></P><P></P><P>please give us more Information or share a sample qvw.</P><P></P><P>Regards</P><P>tim</P></BODY></HTML> Tue, 24 Oct 2017 12:25:53 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422820#M428984 zhadrakas 2017-10-24T12:25:53Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422821#M428985 <HTML><HEAD></HEAD><BODY><P>i have tried it says invalid dimension</P></BODY></HTML> Tue, 24 Oct 2017 12:26:43 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422821#M428985 poojashribanger 2017-10-24T12:26:43Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422822#M428986 <HTML><HEAD></HEAD><BODY><P>Have you tried with your field name in place of 'DateField' ?</P></BODY></HTML> Tue, 24 Oct 2017 12:28:13 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422822#M428986 tresB 2017-10-24T12:28:13Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422823#M428987 <HTML><HEAD></HEAD><BODY><P>i have date field containing all the dates from <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">2016 till present.</SPAN></P><P></P><P>From this field in filter pane I just have to show&nbsp; one single date i.e max(date)&nbsp; In qlik sense</P></BODY></HTML> Tue, 24 Oct 2017 12:29:21 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422823#M428987 poojashribanger 2017-10-24T12:29:21Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422824#M428988 <HTML><HEAD></HEAD><BODY><P>in Dimension you have to use</P><P><STRONG>=aggr(max(DATE_FIELD), DATE_FIELD)</STRONG></P><P></P><P></P></BODY></HTML> Tue, 24 Oct 2017 12:29:46 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422824#M428988 zhadrakas 2017-10-24T12:29:46Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422825#M428989 <HTML><HEAD></HEAD><BODY><P>yes</P><P>max(DT_LCL)</P></BODY></HTML> Tue, 24 Oct 2017 12:29:47 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422825#M428989 poojashribanger 2017-10-24T12:29:47Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422826#M428990 <HTML><HEAD></HEAD><BODY><P>not working still</P></BODY></HTML> Tue, 24 Oct 2017 12:31:06 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422826#M428990 poojashribanger 2017-10-24T12:31:06Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422827#M428991 <HTML><HEAD></HEAD><BODY><P>You are missing <STRONG>total</STRONG>,try like =<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">max(<STRONG>total</STRONG> DT_LCL)</SPAN></P></BODY></HTML> Tue, 24 Oct 2017 12:31:53 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422827#M428991 tresB 2017-10-24T12:31:53Z Re: Max Date on Filter Pane https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422828#M428992 <HTML><HEAD></HEAD><BODY><P>thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>working</P></BODY></HTML> Tue, 24 Oct 2017 12:34:32 GMT https://community.qlik.com/t5/QlikView/Max-Date-on-Filter-Pane/m-p/1422828#M428992 poojashribanger 2017-10-24T12:34:32Z