topic To extract current and previous quarters data. in QlikView https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203212#M60638 <HTML><HEAD></HEAD><BODY><P>u can use <STRONG>Inquarter() or InQuartertodate()</STRONG> functions to get current and Previous quarter</P></BODY></HTML> Tue, 08 Feb 2011 07:08:32 GMT 2011-02-08T07:08:32Z To extract current and previous quarters data. https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203210#M60636 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I want to write a conditon in such a way that i need to extract data for current and previous quarter.</P><P>how do i write condition in script to get that data.</P><P>Plsss help......</P><P>thanks in advance</P></BODY></HTML> Mon, 07 Feb 2011 11:37:03 GMT https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203210#M60636 2011-02-07T11:37:03Z To extract current and previous quarters data. https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203211#M60637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can define a flag in the script like:</P><P style="font-weight: bold">(month(today(0))&amp;Ceil/3) as CurrentQtr</P><P>The same approach can be done for Previous Quarter.</P><P>So every time the Month changes in the system calendar it will affect on Quarter too</P><P>Regards,</P><P>Sunil</P></BODY></HTML> Tue, 08 Feb 2011 04:14:02 GMT https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203211#M60637 2011-02-08T04:14:02Z To extract current and previous quarters data. https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203212#M60638 <HTML><HEAD></HEAD><BODY><P>u can use <STRONG>Inquarter() or InQuartertodate()</STRONG> functions to get current and Previous quarter</P></BODY></HTML> Tue, 08 Feb 2011 07:08:32 GMT https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203212#M60638 2011-02-08T07:08:32Z To extract current and previous quarters data. https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203213#M60639 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>InQuarter etc will only return a true/false statement - if you are looking for 1,2,3,4 then sunils will work but with a slight tweak</P><P></P><P>ceil(month(today(0))/3)</P><P></P><P>The ceil in that location will be seen as a field name.&nbsp;&nbsp; Ceiling the whole result will give you the current quarter</P></BODY></HTML> Tue, 12 Jul 2011 08:21:05 GMT https://community.qlik.com/t5/QlikView/To-extract-current-and-previous-quarters-data/m-p/203213#M60639 2011-07-12T08:21:05Z