topic create a derived field in QlikView https://community.qlik.com/t5/QlikView/create-a-derived-field/m-p/214054#M67654 <HTML><HEAD></HEAD><BODY><P>Hello 3 Idiots,</P><P>perhaps this can serve you as an example:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /> IF(MONTH(MyDate) &lt;4, 'Q1',<BR /> IF(MONTH(Mydate) &lt;7, 'Q2',<BR /> IF(MONTH(MyDate) &lt;10,'Q3',<BR /> IF(MONTH(MyDate) &lt;13,'Q4',<BR /> 'Q5')))) AS MyQuarter,<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Regards, Roland</P></BODY></HTML> Mon, 06 Dec 2010 15:58:55 GMT 2010-12-06T15:58:55Z create a derived field https://community.qlik.com/t5/QlikView/create-a-derived-field/m-p/214053#M67653 <HTML><HEAD></HEAD><BODY><P>how to create a derived field and provide values into it through script</P></BODY></HTML> Mon, 06 Dec 2010 13:34:27 GMT https://community.qlik.com/t5/QlikView/create-a-derived-field/m-p/214053#M67653 2010-12-06T13:34:27Z create a derived field https://community.qlik.com/t5/QlikView/create-a-derived-field/m-p/214054#M67654 <HTML><HEAD></HEAD><BODY><P>Hello 3 Idiots,</P><P>perhaps this can serve you as an example:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR /> IF(MONTH(MyDate) &lt;4, 'Q1',<BR /> IF(MONTH(Mydate) &lt;7, 'Q2',<BR /> IF(MONTH(MyDate) &lt;10,'Q3',<BR /> IF(MONTH(MyDate) &lt;13,'Q4',<BR /> 'Q5')))) AS MyQuarter,<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Regards, Roland</P></BODY></HTML> Mon, 06 Dec 2010 15:58:55 GMT https://community.qlik.com/t5/QlikView/create-a-derived-field/m-p/214054#M67654 2010-12-06T15:58:55Z