topic Re: Date to Quarter in QlikView https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801294#M282804 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached file</P><P></P><P>For quarter conversion write like</P><P>'Q'&amp;Ceil(Num(Month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')))/3)</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 13 Mar 2015 14:58:03 GMT its_anandrjs 2015-03-13T14:58:03Z Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801287#M282797 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Anybody help me for date conversion. Any useful document?</P><P></P><P>In my case I am unable to create quarter.</P><P></P><P>Sample attached..</P></BODY></HTML> Fri, 13 Mar 2015 14:42:27 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801287#M282797 Anonymous 2015-03-13T14:42:27Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801288#M282798 <HTML><HEAD></HEAD><BODY><P>Try it with ceil(month(date) / 3) as quarter.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 13 Mar 2015 14:46:45 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801288#M282798 marcus_sommer 2015-03-13T14:46:45Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801289#M282799 <HTML><HEAD></HEAD><BODY><P>Ceil(Month([ur field])/3) As Quarterly,</P></BODY></HTML> Fri, 13 Mar 2015 14:48:38 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801289#M282799 buzzy996 2015-03-13T14:48:38Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801290#M282800 <HTML><HEAD></HEAD><BODY><P>I get null value, somehow</P><P></P><P>Thanks Marcus</P></BODY></HTML> Fri, 13 Mar 2015 14:49:59 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801290#M282800 Anonymous 2015-03-13T14:49:59Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801291#M282801 <HTML><HEAD></HEAD><BODY><P>Hi Shiva again null value for attached QV</P><P></P><P>Thanks</P></BODY></HTML> Fri, 13 Mar 2015 14:52:25 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801291#M282801 Anonymous 2015-03-13T14:52:25Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801292#M282802 <HTML><HEAD></HEAD><BODY><P>Replace date with your date-fieldname and make sure that it is really a numeric date:</P><P></P><P>ceil(month(<STRONG>YourDateField</STRONG>) / 3) as quarter</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 13 Mar 2015 14:52:40 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801292#M282802 marcus_sommer 2015-03-13T14:52:40Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801293#M282803 <HTML><HEAD></HEAD><BODY><P>Marcus</P><P></P><P>I needed to change formula as</P><P></P><P></P><P>ceil</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">vDate</EM></STRONG></EM></STRONG><EM style="color: #808080; font-size: 8pt;"></EM><EM style="color: #808080; font-size: 8pt;"></EM><SPAN style="color: #000000; font-size: 8pt;">,'DD-MMM-YY'), 'MM/DD/YY')) / 3) </SPAN></P><P></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Fri, 13 Mar 2015 14:57:55 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801293#M282803 Anonymous 2015-03-13T14:57:55Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801294#M282804 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached file</P><P></P><P>For quarter conversion write like</P><P>'Q'&amp;Ceil(Num(Month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')))/3)</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 13 Mar 2015 14:58:03 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801294#M282804 its_anandrjs 2015-03-13T14:58:03Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801295#M282805 <HTML><HEAD></HEAD><BODY><P>Hi Shiva</P><P></P><P>I needed to change formula as</P><P></P><P></P><P></P><P>ceil</P><P></P><P></P><P><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">month</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="color: #000000; font-size: 8pt;">(</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">vDate</EM></STRONG></EM></STRONG><SPAN style="color: #000000; font-size: 8pt;">,'DD-MMM-YY'), 'MM/DD/YY')) / 3) </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #000000;">Thanks for your suggestion and time</SPAN></SPAN></P><P></P><P></P><P><SPAN style="font-size: 12pt;"> </SPAN></P><P><BR /> </P><P></P><P><BR /> </P></BODY></HTML> Fri, 13 Mar 2015 14:58:31 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801295#M282805 Anonymous 2015-03-13T14:58:31Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801296#M282806 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Marcus; Thanks for your suggestion and time</SPAN></P></BODY></HTML> Fri, 13 Mar 2015 14:59:03 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801296#M282806 Anonymous 2015-03-13T14:59:03Z Re: Date to Quarter https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801297#M282807 <HTML><HEAD></HEAD><BODY><P>=Ceil(Num(month(Date(Date#(vDate,'DD-MMM-YY'), 'MM/DD/YY')))/3)</P></BODY></HTML> Fri, 13 Mar 2015 15:06:31 GMT https://community.qlik.com/t5/QlikView/Date-to-Quarter/m-p/801297#M282807 buzzy996 2015-03-13T15:06:31Z