topic Re: How to group date?? in QlikView https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643933#M235954 <HTML><HEAD></HEAD><BODY><P>try this:</P><P><STRONG>Year</STRONG>(ACTUAL_SHIPMENT_DATE) as Year,</P><P><STRONG>MonthName</STRONG>(ACTUAL_SHIPMENT_DATE) as Year_Month</P></BODY></HTML> Mon, 09 Jun 2014 07:25:30 GMT tresB 2014-06-09T07:25:30Z How to group date?? https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643932#M235953 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am reloading Date from my data but its not grouping Date automatically. Please help me to group this date by Year and Year-Month.</P><P>See image:</P><P><IMG alt="Date.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/60305_Date.png" /></P><P>I attached sample application.</P><P>Thanks.</P></BODY></HTML> Mon, 09 Jun 2014 07:20:48 GMT https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643932#M235953 soha1902 2014-06-09T07:20:48Z Re: How to group date?? https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643933#M235954 <HTML><HEAD></HEAD><BODY><P>try this:</P><P><STRONG>Year</STRONG>(ACTUAL_SHIPMENT_DATE) as Year,</P><P><STRONG>MonthName</STRONG>(ACTUAL_SHIPMENT_DATE) as Year_Month</P></BODY></HTML> Mon, 09 Jun 2014 07:25:30 GMT https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643933#M235954 tresB 2014-06-09T07:25:30Z Re: How to group date?? https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643934#M235955 <HTML><HEAD></HEAD><BODY><P>try below</P><P></P><P>Load </P><P></P><P></P><P>Year(ACTUAL_SHIPMENT_DATE) as Year,</P><P>year(ACTUAL_SHIPMENT_DATE)&amp;'-'&amp;Month(ACTUAL_SHIPMENT_DATE) as Year_Month</P><P></P><P></P><P>FROM</P><P>[Data.QVD]</P><P>(qvd)</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 09 Jun 2014 07:29:10 GMT https://community.qlik.com/t5/QlikView/How-to-group-date/m-p/643934#M235955 ashfaq_haseeb 2014-06-09T07:29:10Z