topic Re: Showing data based on current Date/most recent date in QlikView https://community.qlik.com/t5/QlikView/Showing-data-based-on-current-Date-most-recent-date/m-p/752037#M1026369 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;[Inventory Date] = {'$(=Max(<SPAN style="font-size: 13.3333330154419px;">[Inventory Date]</SPAN>))'}&gt;}YourFIeld)</P></BODY></HTML> Thu, 05 Mar 2015 15:25:32 GMT MK_QSL 2015-03-05T15:25:32Z Showing data based on current Date/most recent date https://community.qlik.com/t5/QlikView/Showing-data-based-on-current-Date-most-recent-date/m-p/752036#M1026368 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have Bunch of test boxes in one tab and I would like to show the text box values based on the most recent date by default. My date field is inventory Date.</P><P></P><P>Could you please suggest me?</P><P></P><P>Thanks for your help.</P><P></P><P>Ahmed</P></BODY></HTML> Thu, 05 Mar 2015 15:23:57 GMT https://community.qlik.com/t5/QlikView/Showing-data-based-on-current-Date-most-recent-date/m-p/752036#M1026368 AH 2015-03-05T15:23:57Z Re: Showing data based on current Date/most recent date https://community.qlik.com/t5/QlikView/Showing-data-based-on-current-Date-most-recent-date/m-p/752037#M1026369 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;[Inventory Date] = {'$(=Max(<SPAN style="font-size: 13.3333330154419px;">[Inventory Date]</SPAN>))'}&gt;}YourFIeld)</P></BODY></HTML> Thu, 05 Mar 2015 15:25:32 GMT https://community.qlik.com/t5/QlikView/Showing-data-based-on-current-Date-most-recent-date/m-p/752037#M1026369 MK_QSL 2015-03-05T15:25:32Z