topic Split the Year in Quartiles in QlikView https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425343#M158424 <HTML><HEAD></HEAD><BODY><P>I have loads of dates and I need to split each year into quartiles.</P><P></P><P>How would I do that? As after I will have to display a set of data for each quartile. </P></BODY></HTML> Mon, 11 Feb 2013 16:29:23 GMT 2013-02-11T16:29:23Z Split the Year in Quartiles https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425343#M158424 <HTML><HEAD></HEAD><BODY><P>I have loads of dates and I need to split each year into quartiles.</P><P></P><P>How would I do that? As after I will have to display a set of data for each quartile. </P></BODY></HTML> Mon, 11 Feb 2013 16:29:23 GMT https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425343#M158424 2013-02-11T16:29:23Z Re: Split the Year in Quartiles https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425344#M158425 <HTML><HEAD></HEAD><BODY><P>Ceil(Month(Date)/3) as Quarter</P></BODY></HTML> Mon, 11 Feb 2013 16:31:16 GMT https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425344#M158425 vivientexier 2013-02-11T16:31:16Z Re: Split the Year in Quartiles https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425345#M158426 <HTML><HEAD></HEAD><BODY><P>How would I use this?</P><P></P><P>I need to have 4 quartiles, e.g. dec, jan, feb for each year. Then I have to create a table to display the highest values for each quartile.</P></BODY></HTML> Mon, 11 Feb 2013 16:34:03 GMT https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425345#M158426 2013-02-11T16:34:03Z Re: Split the Year in Quartiles https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425346#M158427 <HTML><HEAD></HEAD><BODY><P>In your script.</P><P></P><P><SPAN style="font-size: 10pt;">You have a date.</SPAN></P><P><BR />Let's create a new field with your date field.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Ceil(Month(Date)/3) as Quarter</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">This formula will give you 1 for January, 1 for February, 1 for march and 2 for April.<BR /></SPAN></P></BODY></HTML> Mon, 11 Feb 2013 16:37:42 GMT https://community.qlik.com/t5/QlikView/Split-the-Year-in-Quartiles/m-p/425346#M158427 vivientexier 2013-02-11T16:37:42Z