topic How to achieve this in QlikView https://community.qlik.com/t5/QlikView/How-to-achieve-this/m-p/85845#M14079 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have a table like below</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144px;"><TBODY><TR><TD height="17" width="72">Level </TD><TD width="72">Account</TD></TR><TR><TD align="right" height="17">10</TD><TD>A123</TD></TR><TR><TD align="right" height="17">11</TD><TD>A245</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">123</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">133</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">143</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">153</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">163</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">173</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">183</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">193</TD></TR><TR><TD align="right" height="17">11</TD><TD>A456</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">456</TD></TR><TR><TD align="right" height="17">11</TD><TD align="right">A466</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">476</TD></TR><TR><TD align="right" height="17">8</TD><TD>A567</TD></TR><TR><TD align="right" height="17">9</TD><TD>A678</TD></TR><TR><TD align="right" height="17">10</TD><TD>A124</TD></TR></TBODY></TABLE><P></P><P></P><P>If I filter the by a where clause A123 it has to check the Level 10 and I need all the numerical values between Level 10 or less than 10 as the result.</P><P>&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="72"><TBODY><TR><TD align="right" height="17" width="72">123</TD></TR><TR><TD align="right" height="17">133</TD></TR><TR><TD align="right" height="17">143</TD></TR><TR><TD align="right" height="17">153</TD></TR><TR><TD align="right" height="17">163</TD></TR><TR><TD align="right" height="17">173</TD></TR><TR><TD align="right" height="17">183</TD></TR><TR><TD align="right" height="17">193</TD></TR><TR><TD align="right" height="17">456</TD></TR><TR><TD align="right" height="17">466</TD></TR><TR><TD align="right" height="17">476</TD></TR></TBODY></TABLE><P>If I select <SPAN style="font-size: 13.3333px;">A245 The result would be </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="72"><TBODY><TR><TD align="right" height="17" width="72">123</TD></TR><TR><TD align="right" height="17">133</TD></TR><TR><TD align="right" height="17">143</TD></TR><TR><TD align="right" height="17">153</TD></TR><TR><TD align="right" height="17">163</TD></TR><TR><TD align="right" height="17">173</TD></TR><TR><TD align="right" height="17">183</TD></TR><TR><TD align="right" height="17"><P>193</P><P></P></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 31 Jul 2018 06:38:58 GMT techvarun 2018-07-31T06:38:58Z How to achieve this https://community.qlik.com/t5/QlikView/How-to-achieve-this/m-p/85845#M14079 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have a table like below</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 144px;"><TBODY><TR><TD height="17" width="72">Level </TD><TD width="72">Account</TD></TR><TR><TD align="right" height="17">10</TD><TD>A123</TD></TR><TR><TD align="right" height="17">11</TD><TD>A245</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">123</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">133</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">143</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">153</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">163</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">173</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">183</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">193</TD></TR><TR><TD align="right" height="17">11</TD><TD>A456</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">456</TD></TR><TR><TD align="right" height="17">11</TD><TD align="right">A466</TD></TR><TR><TD align="right" height="17">12</TD><TD align="right">476</TD></TR><TR><TD align="right" height="17">8</TD><TD>A567</TD></TR><TR><TD align="right" height="17">9</TD><TD>A678</TD></TR><TR><TD align="right" height="17">10</TD><TD>A124</TD></TR></TBODY></TABLE><P></P><P></P><P>If I filter the by a where clause A123 it has to check the Level 10 and I need all the numerical values between Level 10 or less than 10 as the result.</P><P>&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="72"><TBODY><TR><TD align="right" height="17" width="72">123</TD></TR><TR><TD align="right" height="17">133</TD></TR><TR><TD align="right" height="17">143</TD></TR><TR><TD align="right" height="17">153</TD></TR><TR><TD align="right" height="17">163</TD></TR><TR><TD align="right" height="17">173</TD></TR><TR><TD align="right" height="17">183</TD></TR><TR><TD align="right" height="17">193</TD></TR><TR><TD align="right" height="17">456</TD></TR><TR><TD align="right" height="17">466</TD></TR><TR><TD align="right" height="17">476</TD></TR></TBODY></TABLE><P>If I select <SPAN style="font-size: 13.3333px;">A245 The result would be </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="72"><TBODY><TR><TD align="right" height="17" width="72">123</TD></TR><TR><TD align="right" height="17">133</TD></TR><TR><TD align="right" height="17">143</TD></TR><TR><TD align="right" height="17">153</TD></TR><TR><TD align="right" height="17">163</TD></TR><TR><TD align="right" height="17">173</TD></TR><TR><TD align="right" height="17">183</TD></TR><TR><TD align="right" height="17"><P>193</P><P></P></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 31 Jul 2018 06:38:58 GMT https://community.qlik.com/t5/QlikView/How-to-achieve-this/m-p/85845#M14079 techvarun 2018-07-31T06:38:58Z