topic Calculate a variable in QlikView https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831354#M471005 <HTML><HEAD></HEAD><BODY><P>Hello Qlikviewers,</P><P></P><P>I have two variables (varPeildatum, varPlanningsbreedte) and one field (Date). By using the variables i want a selection of</P><P>greater then varPeildatum - varPlanningsbreedte - 1 and</P><P>less then varPeildatum + varPlanningsbreedte + 1</P><P></P><P>The reaction I use is:</P><P>='&gt;='&amp;varPeildatum-varPlanningsbreedte-1&amp;'&lt;='&amp;varPeildatum+varPlanningsbreedte+1</P></BODY></HTML> Tue, 14 Apr 2015 13:58:17 GMT tomhovens 2015-04-14T13:58:17Z Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831354#M471005 <HTML><HEAD></HEAD><BODY><P>Hello Qlikviewers,</P><P></P><P>I have two variables (varPeildatum, varPlanningsbreedte) and one field (Date). By using the variables i want a selection of</P><P>greater then varPeildatum - varPlanningsbreedte - 1 and</P><P>less then varPeildatum + varPlanningsbreedte + 1</P><P></P><P>The reaction I use is:</P><P>='&gt;='&amp;varPeildatum-varPlanningsbreedte-1&amp;'&lt;='&amp;varPeildatum+varPlanningsbreedte+1</P></BODY></HTML> Tue, 14 Apr 2015 13:58:17 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831354#M471005 tomhovens 2015-04-14T13:58:17Z Re: Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831355#M471006 <HTML><HEAD></HEAD><BODY><P>If you are making a selection in date field make sure the format of the date is same as your date field format</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">='&gt;=' &amp; <STRONG>Date(</STRONG>varPeildatum-varPlanningsbreedte-1<STRONG>, 'yourDateFormat') </STRONG>&amp; '&lt;=' &amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Date</STRONG>(</SPAN>varPeildatum+varPlanningsbreedte+1<STRONG style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, 'yourDateFormat')</STRONG></SPAN></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">HTH</SPAN></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Apr 2015 14:05:55 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831355#M471006 sunny_talwar 2015-04-14T14:05:55Z Re: Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831356#M471007 <HTML><HEAD></HEAD><BODY><P>Thanks for your quick answer</P></BODY></HTML> Tue, 14 Apr 2015 14:13:51 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831356#M471007 tomhovens 2015-04-14T14:13:51Z Re: Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831357#M471008 <HTML><HEAD></HEAD><BODY><P>No problem! did it work for you?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Apr 2015 14:15:23 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831357#M471008 sunny_talwar 2015-04-14T14:15:23Z Re: Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831358#M471009 <HTML><HEAD></HEAD><BODY><P>yes (Y)</P></BODY></HTML> Tue, 14 Apr 2015 14:26:33 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831358#M471009 tomhovens 2015-04-14T14:26:33Z Re: Calculate a variable https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831359#M471010 <HTML><HEAD></HEAD><BODY><P>Awesome!</P></BODY></HTML> Tue, 14 Apr 2015 14:27:41 GMT https://community.qlik.com/t5/QlikView/Calculate-a-variable/m-p/831359#M471010 sunny_talwar 2015-04-14T14:27:41Z