topic Re: How to get financial start date of previous year from current date? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360251#M417004 <HTML><HEAD></HEAD><BODY><P>Where are you trying this, set analysis?</P></BODY></HTML> Mon, 07 Aug 2017 10:16:59 GMT Anil_Babu_Samineni 2017-08-07T10:16:59Z How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360250#M417003 <HTML><HEAD></HEAD><BODY><P>I have startdate &amp; enddate of current year.</P><P>e.g.</P><P>Now If any1 select enddate = '<STRONG>1 May 2017</STRONG>' , then I want startdate = '<STRONG>1 Apr</STRONG> <STRONG>2016</STRONG>' &amp; enddate = '<STRONG>1 May</STRONG> <STRONG>2016</STRONG>'</P><P>My expression will be lastyear be like</P><P>=dateField &gt; startdate and dateField &lt; enddate.</P></BODY></HTML> Mon, 07 Aug 2017 10:10:57 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360250#M417003 Shubham_Deshmukh 2017-08-07T10:10:57Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360251#M417004 <HTML><HEAD></HEAD><BODY><P>Where are you trying this, set analysis?</P></BODY></HTML> Mon, 07 Aug 2017 10:16:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360251#M417004 Anil_Babu_Samineni 2017-08-07T10:16:59Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360252#M417005 <HTML><HEAD></HEAD><BODY><P>Nope.Simple If else thats it.</P></BODY></HTML> Mon, 07 Aug 2017 10:22:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360252#M417005 Shubham_Deshmukh 2017-08-07T10:22:40Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360253#M417006 <HTML><HEAD></HEAD><BODY><P>For not considering current selections I will have to use set analysis thats it.</P></BODY></HTML> Mon, 07 Aug 2017 10:24:03 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360253#M417006 Shubham_Deshmukh 2017-08-07T10:24:03Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360254#M417007 <HTML><HEAD></HEAD><BODY><P>To simplify try this</P><P></P><P>If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 28.6924px;">dateField &gt; startdate and dateField &lt; enddate, requiredfield)</SPAN></P><P></P><P>And set analysis may be this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 28.6924px;">Only({&lt;dateField = {"=dateField &gt; startdate and =dateField &lt; enddate"} &gt;} measure)</SPAN></P></BODY></HTML> Mon, 07 Aug 2017 10:27:40 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360254#M417007 Anil_Babu_Samineni 2017-08-07T10:27:40Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360255#M417008 <HTML><HEAD></HEAD><BODY><P>Done Sir.</P><P>M getting previous year Financial yr start by using this,</P><P><STRONG>=AddYears(makedate(year(Enddate),4),-1) gives 1 Apr of lastyear</STRONG></P></BODY></HTML> Mon, 07 Aug 2017 10:29:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360255#M417008 Shubham_Deshmukh 2017-08-07T10:29:25Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360256#M417009 <HTML><HEAD></HEAD><BODY><P>Your question is not similar to original thread</P><P></P><P>Anyway, mark your response as correct to close this thread</P></BODY></HTML> Mon, 07 Aug 2017 10:32:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360256#M417009 Anil_Babu_Samineni 2017-08-07T10:32:21Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360257#M417010 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Mon, 07 Aug 2017 10:43:32 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360257#M417010 Shubham_Deshmukh 2017-08-07T10:43:32Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360258#M417011 <HTML><HEAD></HEAD><BODY><P>How to mark as correct ans?</P></BODY></HTML> Mon, 07 Aug 2017 10:44:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360258#M417011 Shubham_Deshmukh 2017-08-07T10:44:59Z Re: How to get financial start date of previous year from current date? https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360259#M417012 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Mon, 07 Aug 2017 11:44:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-financial-start-date-of-previous-year-from-current/m-p/1360259#M417012 Anil_Babu_Samineni 2017-08-07T11:44:43Z