topic Creating Quarters, why do i get a single Q? in QlikView https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259660#M98025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It is due to the null values you just need to exclude null values try the below code </P><P>If(isnull(DateColumn) = 0, 'Q' &amp; Ceil(Month(Date(DateColumn))/3)) as Quarter by this you exclude null values.</P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Tue, 09 Aug 2011 14:05:19 GMT its_anandrjs 2011-08-09T14:05:19Z Creating Quarters, why do i get a single Q? https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259659#M98024 <HTML><HEAD></HEAD><BODY><DIV><SPAN style="color: #000000; font-size: 10pt;">Hi, </SPAN></DIV><DIV> </DIV><DIV><SPAN style="color: #000000; font-size: 10pt;"> I'm using next formula to compute quarters based on a dataset from an xls:<DIV> </DIV></SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 10pt;">This way I end op with </SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 10pt;">Q1, Q2, ,Q3, Q4 and a Q in my selection boxes. How can i get rid of it? </SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 10pt;"> </SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 8pt;">Thanx! </SPAN></DIV><DIV><SPAN style="color: #800000; font-size: 8pt;"> </SPAN></DIV></BODY></HTML> Tue, 09 Aug 2011 13:29:55 GMT https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259659#M98024 2011-08-09T13:29:55Z Creating Quarters, why do i get a single Q? https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259660#M98025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It is due to the null values you just need to exclude null values try the below code </P><P>If(isnull(DateColumn) = 0, 'Q' &amp; Ceil(Month(Date(DateColumn))/3)) as Quarter by this you exclude null values.</P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Tue, 09 Aug 2011 14:05:19 GMT https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259660#M98025 its_anandrjs 2011-08-09T14:05:19Z Creating Quarters, why do i get a single Q? https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259661#M98026 <HTML><HEAD></HEAD><BODY><P> Thankx!</P></BODY></HTML> Tue, 09 Aug 2011 14:09:57 GMT https://community.qlik.com/t5/QlikView/Creating-Quarters-why-do-i-get-a-single-Q/m-p/259661#M98026 2011-08-09T14:09:57Z