topic Re: Grouping in QlikView https://community.qlik.com/t5/QlikView/Grouping/m-p/408969#M558576 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>Use this dimension or script</P><P></P><P>Ex: =if<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SubField</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Range</SPAN><SPAN style="font-size: 8pt;">,'-',2)&lt;=15,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dual</SPAN><SPAN style="font-size: 8pt;">('0-15',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Range</SPAN><SPAN style="font-size: 8pt;">)) .</SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Find the attached file</SPAN></P></BODY></HTML> Mon, 27 May 2013 06:12:10 GMT kumarnatarajan 2013-05-27T06:12:10Z Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/408968#M558575 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P> i have&nbsp; one&nbsp;&nbsp; filed&nbsp; like&nbsp;&nbsp;&nbsp; Data:</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; 0-5</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; 5-10</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; 10-15</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; 20-25</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; 25-30</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; 30- 35</P><P>];</P><P></P><P></P><P> my output like&nbsp;&nbsp;&nbsp;&nbsp; 0-15&nbsp; only </P></BODY></HTML> Mon, 27 May 2013 06:01:00 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/408968#M558575 2013-05-27T06:01:00Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/408969#M558576 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>Use this dimension or script</P><P></P><P>Ex: =if<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">SubField</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Range</SPAN><SPAN style="font-size: 8pt;">,'-',2)&lt;=15,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Dual</SPAN><SPAN style="font-size: 8pt;">('0-15',</SPAN><SPAN style="color: #800000; font-size: 8pt;">Range</SPAN><SPAN style="font-size: 8pt;">)) .</SPAN></P><P></P><P></P><P></P><P><SPAN style="font-size: 8pt;">Find the attached file</SPAN></P></BODY></HTML> Mon, 27 May 2013 06:12:10 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/408969#M558576 kumarnatarajan 2013-05-27T06:12:10Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/408970#M558577 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>&nbsp;&nbsp; Please use the below code in the where clause while loading the table.</P><P></P><P><STRONG>Where&nbsp;&nbsp; </STRONG><STRONG>(SubField(Data,'-',1)&gt;=0) and (SubField(Data,'-',2)&lt;=15);</STRONG></P><P></P><P></P><P>Regards</P><P>Yusuf <STRONG><BR /></STRONG></P></BODY></HTML> Mon, 27 May 2013 06:12:28 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/408970#M558577 2013-05-27T06:12:28Z Re: Grouping https://community.qlik.com/t5/QlikView/Grouping/m-p/408971#M558578 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Mon, 27 May 2013 06:19:25 GMT https://community.qlik.com/t5/QlikView/Grouping/m-p/408971#M558578 2013-05-27T06:19:25Z