topic Re: Date Creation in QlikView https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145290#M912034 <HTML><HEAD></HEAD><BODY><P>Cool but can u help me to cross a set of data as a sample for me to execute others. Pls see the attached excel file. Thanks man</P></BODY></HTML> Tue, 07 Jun 2016 20:22:45 GMT akpofureenughwu 2016-06-07T20:22:45Z Date Creation https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145288#M912030 <HTML><HEAD></HEAD><BODY><P>Good day everyone. I need help. I need to create date from a field as shown from the attached file. How do I get date, month, quarter from the date availabe in the attached file. Please assist me? Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145288#M912030 akpofureenughwu 2020-11-25T16:16:04Z Re: Date Creation https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145289#M912033 <HTML><HEAD></HEAD><BODY><P>I think it would be best if you use CrossTable load to change the MonthYear into rows. Look here on how to do it:</P><P><A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A></P><P></P><P>Once you do this, all manipulations will be very easy</P></BODY></HTML> Tue, 07 Jun 2016 20:12:26 GMT https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145289#M912033 sunny_talwar 2016-06-07T20:12:26Z Re: Date Creation https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145290#M912034 <HTML><HEAD></HEAD><BODY><P>Cool but can u help me to cross a set of data as a sample for me to execute others. Pls see the attached excel file. Thanks man</P></BODY></HTML> Tue, 07 Jun 2016 20:22:45 GMT https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145290#M912034 akpofureenughwu 2016-06-07T20:22:45Z Re: Date Creation https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145291#M912035 <HTML><HEAD></HEAD><BODY><P>See if the attached make sense</P></BODY></HTML> Tue, 07 Jun 2016 20:29:05 GMT https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145291#M912035 sunny_talwar 2016-06-07T20:29:05Z Re: Date Creation https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145292#M912036 <HTML><HEAD></HEAD><BODY><P>Bravo sir, But can you help me with the day as a field please so I can drill from year to quarter to month to day. Thanks so far man</P></BODY></HTML> Tue, 07 Jun 2016 20:36:05 GMT https://community.qlik.com/t5/QlikView/Date-Creation/m-p/1145292#M912036 akpofureenughwu 2016-06-07T20:36:05Z