topic Re: Range selection in QlikView https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047327#M925899 <HTML><HEAD></HEAD><BODY><P>May be like attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120388_Capture.PNG" style="height: 194px; width: 620px;" /></P></BODY></HTML> Mon, 04 Apr 2016 10:43:38 GMT sunny_talwar 2016-04-04T10:43:38Z Range selection https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047324#M925896 <HTML><HEAD></HEAD><BODY><P>HI Community,</P><P></P><P>I facing one problem..</P><P>I would like to create range wise chart..</P><P>If I am give range From and to</P><P></P><P>I want to filter data..</P><P>Example:</P><P><STRONG>Client,&nbsp; Type, Amount</STRONG></P><P>A, AC, 100</P><P>A, AC,200</P><P>A,AC,400</P><P>B,AC,30</P><P>B, AC, 50</P><P>C, AC, 250</P><P>C, AC, 45</P><P></P><P>Chart:</P><P>Client&nbsp;&nbsp; Type&nbsp; Sum(Amount)</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 295</P><P></P><P>Here My requirement..</P><P>Range&nbsp; <STRONG>From:&nbsp;&nbsp; 50</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</STRONG></P><P></P><P><STRONG>Output Should Be</STRONG></P><P><STRONG>Client&nbsp;&nbsp; Type&nbsp; Sum(Amount)</STRONG></P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 295</P><P></P><P></P><P>Thanks In Advance...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047324#M925896 paulwalker 2020-11-25T16:16:04Z Re: Range selection https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047325#M925897 <HTML><HEAD></HEAD><BODY><P>try expression</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({&lt;Client ={"=sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Amount)&gt;=50 and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Amount)&lt;=500</SPAN></SPAN>"}&gt;}Amount)</STRONG></SPAN></P></BODY></HTML> Mon, 04 Apr 2016 10:39:50 GMT https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047325#M925897 Kushal_Chawda 2016-04-04T10:39:50Z Re: Range selection https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047326#M925898 <HTML><HEAD></HEAD><BODY><P>Use this..</P></BODY></HTML> Mon, 04 Apr 2016 10:40:51 GMT https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047326#M925898 MK_QSL 2016-04-04T10:40:51Z Re: Range selection https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047327#M925899 <HTML><HEAD></HEAD><BODY><P>May be like attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120388_Capture.PNG" style="height: 194px; width: 620px;" /></P></BODY></HTML> Mon, 04 Apr 2016 10:43:38 GMT https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047327#M925899 sunny_talwar 2016-04-04T10:43:38Z Re: Range selection https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047328#M925900 <HTML><HEAD></HEAD><BODY><P>chk attachmnt</P></BODY></HTML> Mon, 04 Apr 2016 10:48:44 GMT https://community.qlik.com/t5/QlikView/Range-selection/m-p/1047328#M925900 Chanty4u 2016-04-04T10:48:44Z