topic Negative Item List in QlikView https://community.qlik.com/t5/QlikView/Negative-Item-List/m-p/1060385#M355017 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i want to show the customer wise product list for a month where there is no sales for the items.</P><P>Below i am adding a example to make it understand.</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="157"><TBODY><TR><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="157"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">ITEM MASTER</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMNAME</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">XYZ</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ABC</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">DEF</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">GHI</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="297"><TBODY><TR><TD colspan="4" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="297"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">SALES DETAILS</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">CUSTOMER</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">DATE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">SALESQTY</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">01-04-2015</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">01-04-2015</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Result should be</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt; width: 223px;"><TBODY><TR><TD colspan="3" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="223"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">NEGATIVE ITEM LIST</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">CUSTOMER</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMNAME</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">ITEM3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">DEF</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">ITEM4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">GHI</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Can anybody help please.</P><P></P><P>Regards,</P><P>Ajith</P></BODY></HTML> Sat, 23 Jan 2016 10:39:34 GMT ajithsachin 2016-01-23T10:39:34Z Negative Item List https://community.qlik.com/t5/QlikView/Negative-Item-List/m-p/1060385#M355017 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i want to show the customer wise product list for a month where there is no sales for the items.</P><P>Below i am adding a example to make it understand.</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="157"><TBODY><TR><TD colspan="2" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="157"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">ITEM MASTER</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMNAME</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">XYZ</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ABC</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">DEF</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="81"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">GHI</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="297"><TBODY><TR><TD colspan="4" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="297"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">SALES DETAILS</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">CUSTOMER</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">DATE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">SALESQTY</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">01-04-2015</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="73"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">ITEM2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="77"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">01-04-2015</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="69"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">15</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Result should be</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt; width: 223px;"><TBODY><TR><TD colspan="3" nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="223"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="color: black;">NEGATIVE ITEM LIST</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">CUSTOMER</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMCODE</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #00B050; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><STRONG style="color: black;">ITEMNAME</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">ITEM3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">DEF</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">CUST1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">ITEM4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P style="margin-bottom: .0001pt;"><SPAN style="color: #000000; font-size: 13.3333px;">GHI</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Can anybody help please.</P><P></P><P>Regards,</P><P>Ajith</P></BODY></HTML> Sat, 23 Jan 2016 10:39:34 GMT https://community.qlik.com/t5/QlikView/Negative-Item-List/m-p/1060385#M355017 ajithsachin 2016-01-23T10:39:34Z Re: Negative Item List https://community.qlik.com/t5/QlikView/Negative-Item-List/m-p/1060386#M355018 <HTML><HEAD></HEAD><BODY><P><SPAN style="text-decoration: underline;">If you have a CUSTOMER selected</SPAN>, create a straight table chart with <SPAN style="font-size: 10pt; line-height: 1.5em;">dimension ITEMCODE</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">and two expressions:</SPAN></P><P></P><P>=Only({1&lt;ITEMCODE = e() &gt;} ITEMNAME)</P><P>='($=CUSTOMER)'</P><P></P><P>Drag the columns where you like.</P></BODY></HTML> Sat, 23 Jan 2016 11:55:19 GMT https://community.qlik.com/t5/QlikView/Negative-Item-List/m-p/1060386#M355018 swuehl 2016-01-23T11:55:19Z