topic Re: Values between range in QlikView https://community.qlik.com/t5/QlikView/Values-between-range/m-p/1288173#M865132 <HTML><HEAD></HEAD><BODY><P>Create 2 variables for the start and end data ...</P><P>vStartdate</P><P>vEnddate</P><P></P><P>then if(date&gt;=<SPAN style="font-size: 13.3333px;">vStartdate and <SPAN style="font-size: 13.3333px;">date&lt;=<SPAN style="font-size: 13.3333px;">vEnddate,Sum(Sales)</SPAN></SPAN></SPAN>)</P><P></P><P>or </P><P></P><P>sum({&lt;<SPAN style="font-size: 13.3333px;">date={&gt;='$(<SPAN style="font-size: 13.3333px;">vStartdate</SPAN>)'&lt;=<SPAN style="font-size: 13.3333px;">'$(<SPAN style="font-size: 13.3333px;">vEnddate</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)'</SPAN>}</SPAN>&gt;}<SPAN style="font-size: 13.3333px;">Sales</SPAN>)</P></BODY></HTML> Tue, 20 Dec 2016 07:27:40 GMT avinashelite 2016-12-20T07:27:40Z Values between range https://community.qlik.com/t5/QlikView/Values-between-range/m-p/1288172#M865131 <HTML><HEAD></HEAD><BODY><P>Hello to all genius,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have one date column and sales column, If i select from and to date , the sum of sales between the dates must be shown. How can i done pls let me know..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Values-between-range/m-p/1288172#M865131 praveenkumar_s 2020-11-25T16:16:04Z Re: Values between range https://community.qlik.com/t5/QlikView/Values-between-range/m-p/1288173#M865132 <HTML><HEAD></HEAD><BODY><P>Create 2 variables for the start and end data ...</P><P>vStartdate</P><P>vEnddate</P><P></P><P>then if(date&gt;=<SPAN style="font-size: 13.3333px;">vStartdate and <SPAN style="font-size: 13.3333px;">date&lt;=<SPAN style="font-size: 13.3333px;">vEnddate,Sum(Sales)</SPAN></SPAN></SPAN>)</P><P></P><P>or </P><P></P><P>sum({&lt;<SPAN style="font-size: 13.3333px;">date={&gt;='$(<SPAN style="font-size: 13.3333px;">vStartdate</SPAN>)'&lt;=<SPAN style="font-size: 13.3333px;">'$(<SPAN style="font-size: 13.3333px;">vEnddate</SPAN></SPAN><SPAN style="font-size: 13.3333px;">)'</SPAN>}</SPAN>&gt;}<SPAN style="font-size: 13.3333px;">Sales</SPAN>)</P></BODY></HTML> Tue, 20 Dec 2016 07:27:40 GMT https://community.qlik.com/t5/QlikView/Values-between-range/m-p/1288173#M865132 avinashelite 2016-12-20T07:27:40Z