topic Re: How to get data for different periods. in QlikView https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078518#M921672 <HTML><HEAD></HEAD><BODY><P>For Last Year - Call_Year={"$(=DATE(FLOOR(YearStart(Today())),'YYYY'))"}</P><P>For last 7 days - ,Call_Date={"&gt;=$(=Date(today()- 6))&lt;=$(=Date(today()))"}</P></BODY></HTML> Thu, 21 Apr 2016 17:42:21 GMT Pulkit_Thukral 2016-04-21T17:42:21Z How to get data for different periods. https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078516#M921670 <HTML><HEAD></HEAD><BODY><P>Hi, how can i get data for different periods,</P><P>last day ,</P><P>last 7 days,</P><P>last month complete.</P><P>this year.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078516#M921670 2020-11-25T16:16:04Z Re: How to get data for different periods. https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078517#M921671 <HTML><HEAD></HEAD><BODY><P>I am guessing you want this in the front end, right? Use set analysis with variable. Do you have a specific dataset you want us to help you with?</P></BODY></HTML> Thu, 21 Apr 2016 16:50:29 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078517#M921671 sunny_talwar 2016-04-21T16:50:29Z Re: How to get data for different periods. https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078518#M921672 <HTML><HEAD></HEAD><BODY><P>For Last Year - Call_Year={"$(=DATE(FLOOR(YearStart(Today())),'YYYY'))"}</P><P>For last 7 days - ,Call_Date={"&gt;=$(=Date(today()- 6))&lt;=$(=Date(today()))"}</P></BODY></HTML> Thu, 21 Apr 2016 17:42:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078518#M921672 Pulkit_Thukral 2016-04-21T17:42:21Z Re: How to get data for different periods. https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078519#M921673 <HTML><HEAD></HEAD><BODY><P>For last 1 day - <SPAN style="color: #800000; font-size: 8pt;">ArrivalDate</SPAN><SPAN style="font-size: 8pt;">={'$(=Date(today()-1))'} </SPAN></P></BODY></HTML> Thu, 21 Apr 2016 17:48:26 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-for-different-periods/m-p/1078519#M921673 Pulkit_Thukral 2016-04-21T17:48:26Z