topic Re: selected the range in QlikView https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411746#M566573 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;ID={"&gt;=$(=vLowerLimit)&lt;=$(=vUpperLimit)"}&gt;}Sales)</P></BODY></HTML> Thu, 06 Dec 2012 18:12:03 GMT MayilVahanan 2012-12-06T18:12:03Z selected the range https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411743#M566566 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P> i can create two varible&nbsp; Vupperlimit,Vlowerlimit</P><P></P><P>user have to enter the range&nbsp; through input box&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lowerlimit&nbsp;&nbsp;&nbsp; upperlimit</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp; </P><P> the data should in&nbsp; the range only in&nbsp; any table.</P></BODY></HTML> Thu, 06 Dec 2012 06:03:10 GMT https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411743#M566566 2012-12-06T06:03:10Z Re: selected the range https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411744#M566568 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We can do this through Dimension Limits in a property page.</P></BODY></HTML> Thu, 06 Dec 2012 07:13:08 GMT https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411744#M566568 2012-12-06T07:13:08Z Re: selected the range https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411745#M566570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please check attached file.</P></BODY></HTML> Thu, 06 Dec 2012 17:56:33 GMT https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411745#M566570 CELAMBARASAN 2012-12-06T17:56:33Z Re: selected the range https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411746#M566573 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>=Sum({&lt;ID={"&gt;=$(=vLowerLimit)&lt;=$(=vUpperLimit)"}&gt;}Sales)</P></BODY></HTML> Thu, 06 Dec 2012 18:12:03 GMT https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411746#M566573 MayilVahanan 2012-12-06T18:12:03Z Re: selected the range https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411747#M566575 <HTML><HEAD></HEAD><BODY><P>I used the csv file attached.</P><P></P><P>Created variables vLowerLimit and vUpperLimit.</P><P>Created input box &amp; added those variables.</P><P>Created Straight table using ID as dimension </P><P>Expression as =Sum({&lt;ID={"&gt;=$(vLowerLimit)&lt;=$(vUpperLimit)"}&gt;} Sales)</P><P></P><P>It works for me.</P><P></P><P>Also for selected field based report check this link </P><P><A class="loading" href="http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Whats%20New%20in%20QlikView11.qvw&amp;host=Demo11" title="http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Whats%20New%20in%20QlikView11.qvw&amp;host=Demo11">http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Whats%20New%20in%20QlikView11.qvw&amp;host=Demo11</A></P><P></P><P>and see the reports tab. Same file you can find in ur installation path.</P></BODY></HTML> Mon, 10 Dec 2012 17:25:25 GMT https://community.qlik.com/t5/QlikView/selected-the-range/m-p/411747#M566575 CELAMBARASAN 2012-12-10T17:25:25Z