topic Re: How to use get_current_feild function for selection of date range in calender in QlikView https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455347#M794987 <HTML><HEAD></HEAD><BODY><P>i have declared variable as vstart=getcurrentselection(sold_date) </P><P>is this correct?</P></BODY></HTML> Wed, 27 Dec 2017 07:31:39 GMT Anonymous 2017-12-27T07:31:39Z How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455342#M794982 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want if I select date range from 1st jan 2014 till 2nd feb 2016 then the data 2016 should become current year and date 2014 should become previous year in chart so for that how to declare variable vstart (starting date in calender) and variable vend(ending date in calender)</P><P></P><P>also what will be the corresponding expressions for both previous year and current year sales in charts <IMG alt="finalsales.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188209_finalsales.png" style="height: 163px; width: 620px;" /></P><P>i have used these expressions&nbsp; for current year and previous year</P><P>previous year</P><P>=num(sum(if(Sold_Date &gt;=vstart and Sold_Date&lt;= vend, [inv value]/Sales_INR_Unit)),'#,##0.0')</P><P>current year</P><P>=num(sum(if(Sold_Date &gt;=vstart and Sold_Date&lt;= vend ,[inv value]/Sales_INR_Unit)),'#,##0.0')</P><P>but both previous year and current year are giving same values</P><P>so please suggest the appropriate expressions ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455342#M794982 Anonymous 2020-11-25T16:16:04Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455343#M794983 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>=num(sum(if(Sold_Date &gt;=<STRONG>AddYears(vstart,1)</STRONG> and Sold_Date&lt;= vend, [inv value]/Sales_INR_Unit)),'#,##0.0')</P></BODY></HTML> Wed, 27 Dec 2017 07:12:30 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455343#M794983 Anil_Babu_Samineni 2017-12-27T07:12:30Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455344#M794984 <HTML><HEAD></HEAD><BODY><P>is this expression used for previous year?</P></BODY></HTML> Wed, 27 Dec 2017 07:28:23 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455344#M794984 Anonymous 2017-12-27T07:28:23Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455345#M794985 <HTML><HEAD></HEAD><BODY><P>s</P></BODY></HTML> Wed, 27 Dec 2017 07:29:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455345#M794985 Anil_Babu_Samineni 2017-12-27T07:29:08Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455346#M794986 <HTML><HEAD></HEAD><BODY><P>what about current year? that wil remain same?</P></BODY></HTML> Wed, 27 Dec 2017 07:30:20 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455346#M794986 Anonymous 2017-12-27T07:30:20Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455347#M794987 <HTML><HEAD></HEAD><BODY><P>i have declared variable as vstart=getcurrentselection(sold_date) </P><P>is this correct?</P></BODY></HTML> Wed, 27 Dec 2017 07:31:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455347#M794987 Anonymous 2017-12-27T07:31:39Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455348#M794988 <HTML><HEAD></HEAD><BODY><P>What you shown in line is correct to me? Are you facing any challenge. If you want to test them use Text object to understand how and what it returned?</P></BODY></HTML> Wed, 27 Dec 2017 09:00:26 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455348#M794988 Anil_Babu_Samineni 2017-12-27T09:00:26Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455349#M794989 <HTML><HEAD></HEAD><BODY><P>yes i am facing one problem if i am using date range from 1st jan 2017 to 15th jan 2017 the data in previous year is displayed as o and current year has got some sales.</P><P>but i want on selecting date 1st jan 2017 to 15th jan 2017 under previous year the value should not be displayed as 0 rather it should have value one year prior to current year <IMG alt="finalsales.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188234_finalsales.png" style="height: 185px; width: 620px;" /></P></BODY></HTML> Wed, 27 Dec 2017 09:42:59 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455349#M794989 Anonymous 2017-12-27T09:42:59Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455350#M794990 <HTML><HEAD></HEAD><BODY><P>Try this for Prev year and show the same image?</P><P></P><P><STRONG>=num(sum(if(Sold_Date &gt;=AddYears(vstart, -1) and Sold_Date&lt;= AddYears(vend, -1), [inv value]/Sales_INR_Unit)),'#,##0.0')</STRONG></P></BODY></HTML> Wed, 27 Dec 2017 09:46:32 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455350#M794990 Anil_Babu_Samineni 2017-12-27T09:46:32Z Re: How to use get_current_feild function for selection of date range in calender https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455351#M794991 <HTML><HEAD></HEAD><BODY><P>I believe you got hat you need, So i would request you to do your job to close this thread by flag "Correct Answer" for next lander users can easy understand the same situation.. </P><P></P><P>Best,</P><P>Anil</P></BODY></HTML> Wed, 27 Dec 2017 11:46:23 GMT https://community.qlik.com/t5/QlikView/How-to-use-get-current-feild-function-for-selection-of-date/m-p/1455351#M794991 Anil_Babu_Samineni 2017-12-27T11:46:23Z