topic Min Week Ending date in current selection in QlikView https://community.qlik.com/t5/QlikView/Min-Week-Ending-date-in-current-selection/m-p/1178553#M630250 <HTML><HEAD></HEAD><BODY><P>Could someone help with Set Analysis. For example I have [Week_Ending_Date] field and selected following weeks:</P><P>7/2/2016</P><P>7/9/2016</P><P>6/25/2016</P><P>How can I chose only min Week_Ending_Date from current selection - 6/25/2016?</P></BODY></HTML> Fri, 29 Jul 2016 15:18:08 GMT vchuprina 2016-07-29T15:18:08Z Min Week Ending date in current selection https://community.qlik.com/t5/QlikView/Min-Week-Ending-date-in-current-selection/m-p/1178553#M630250 <HTML><HEAD></HEAD><BODY><P>Could someone help with Set Analysis. For example I have [Week_Ending_Date] field and selected following weeks:</P><P>7/2/2016</P><P>7/9/2016</P><P>6/25/2016</P><P>How can I chose only min Week_Ending_Date from current selection - 6/25/2016?</P></BODY></HTML> Fri, 29 Jul 2016 15:18:08 GMT https://community.qlik.com/t5/QlikView/Min-Week-Ending-date-in-current-selection/m-p/1178553#M630250 vchuprina 2016-07-29T15:18:08Z Re: Min Week Ending date in current selection https://community.qlik.com/t5/QlikView/Min-Week-Ending-date-in-current-selection/m-p/1178554#M630251 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please try this ...</P><P></P><P>I am thinking you have missed the aggr field to calculate <SPAN style="color: #ff0000; font-family: Helvetica, sans-serif; font-size: 13.3333330154419px;">Yourfield</SPAN></P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Helvetica',sans-serif; color: #3d3d3d;">Sum({$&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> [Week_Ending_Date]</SPAN>={"$(=Date((Min(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> [Week_Ending_Date]</SPAN>)), 'MM/DD/YYYY'))"}&gt;}<SPAN style="color: #ff0000;"> Yourfield)</SPAN></SPAN></P><P><SPAN style="color: #ff0000; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;">other wise</SPAN></P><P><SPAN style="color: #ff0000; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #ff0000; font-size: 10.0pt; font-family: 'Helvetica',sans-serif;"><SPAN style="color: #000000;">we have to use&nbsp;&nbsp;&nbsp; P or E for set analysis</SPAN><BR /></SPAN></P></BODY></HTML> Fri, 29 Jul 2016 15:29:46 GMT https://community.qlik.com/t5/QlikView/Min-Week-Ending-date-in-current-selection/m-p/1178554#M630251 Anonymous 2016-07-29T15:29:46Z