topic Exclude lines in QlikView https://community.qlik.com/t5/QlikView/Exclude-lines/m-p/1079030#M926777 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have below straight table in my QV file.</P><P></P><P>I need to exclude the data where entry date = 20/11/2015 and exclude relative lines on the basis of 'Key'</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 216px; height: 59px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Key</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Entry Date</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="text-decoration: line-through;">985469</SPAN></TD><TD><SPAN style="text-decoration: line-through;">45</SPAN></TD><TD><SPAN style="text-decoration: line-through;">28/10/2015</SPAN></TD></TR><TR><TD><SPAN style="text-decoration: line-through;">985469</SPAN></TD><TD><SPAN style="text-decoration: line-through;">46</SPAN></TD><TD style="padding: 2px;"><SPAN style="text-decoration: line-through;">20/11/2015</SPAN></TD></TR><TR><TD>45687</TD><TD>78</TD><TD>04/11/2015</TD></TR></TBODY></TABLE><P></P><P>Thanks a lot</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Exclude lines https://community.qlik.com/t5/QlikView/Exclude-lines/m-p/1079030#M926777 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have below straight table in my QV file.</P><P></P><P>I need to exclude the data where entry date = 20/11/2015 and exclude relative lines on the basis of 'Key'</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid #000000; width: 216px; height: 59px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Key</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Entry Date</STRONG></TH></TR><TR><TD style="padding: 2px;"><SPAN style="text-decoration: line-through;">985469</SPAN></TD><TD><SPAN style="text-decoration: line-through;">45</SPAN></TD><TD><SPAN style="text-decoration: line-through;">28/10/2015</SPAN></TD></TR><TR><TD><SPAN style="text-decoration: line-through;">985469</SPAN></TD><TD><SPAN style="text-decoration: line-through;">46</SPAN></TD><TD style="padding: 2px;"><SPAN style="text-decoration: line-through;">20/11/2015</SPAN></TD></TR><TR><TD>45687</TD><TD>78</TD><TD>04/11/2015</TD></TR></TBODY></TABLE><P></P><P>Thanks a lot</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-lines/m-p/1079030#M926777 Anonymous 2020-11-25T16:16:04Z Re: Exclude lines https://community.qlik.com/t5/QlikView/Exclude-lines/m-p/1079031#M926778 <HTML><HEAD></HEAD><BODY><P>May be this as your set analysis:</P><P></P><P><STRONG>{&lt;Key = e({&lt;[Entry Date] = {'20/11/2015'}&gt;})&gt;}</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119570_Capture.PNG" style="height: 92px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 28 Mar 2016 15:29:44 GMT https://community.qlik.com/t5/QlikView/Exclude-lines/m-p/1079031#M926778 sunny_talwar 2016-03-28T15:29:44Z