topic erasing rows in a table chart in QlikView https://community.qlik.com/t5/QlikView/erasing-rows-in-a-table-chart/m-p/410398#M560772 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i have a pivot table with&nbsp; documents as dimension and a sum expression.</P><P></P><P>something like this...</P><P>Document&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>&nbsp;&nbsp;&nbsp; vc-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp; vc-2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>&nbsp;&nbsp;&nbsp;&nbsp; vc-3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -100</P><P>total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P>i need to do in the chart if any document have the same value in negative of other erase the two of them...</P><P></P><P>and the table looks something like...</P><P></P><P>Document&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>&nbsp;&nbsp;&nbsp; vc-2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P></P><P>how can i do this...</P><P></P><P></P><P>Thanks...</P></BODY></HTML> Mon, 01 Apr 2013 16:32:52 GMT 2013-04-01T16:32:52Z erasing rows in a table chart https://community.qlik.com/t5/QlikView/erasing-rows-in-a-table-chart/m-p/410398#M560772 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P>i have a pivot table with&nbsp; documents as dimension and a sum expression.</P><P></P><P>something like this...</P><P>Document&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>&nbsp;&nbsp;&nbsp; vc-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp; vc-2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>&nbsp;&nbsp;&nbsp;&nbsp; vc-3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -100</P><P>total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P>i need to do in the chart if any document have the same value in negative of other erase the two of them...</P><P></P><P>and the table looks something like...</P><P></P><P>Document&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>&nbsp;&nbsp;&nbsp; vc-2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P>total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50</P><P></P><P></P><P>how can i do this...</P><P></P><P></P><P>Thanks...</P></BODY></HTML> Mon, 01 Apr 2013 16:32:52 GMT https://community.qlik.com/t5/QlikView/erasing-rows-in-a-table-chart/m-p/410398#M560772 2013-04-01T16:32:52Z Re: erasing rows in a table chart https://community.qlik.com/t5/QlikView/erasing-rows-in-a-table-chart/m-p/410399#M560773 <HTML><HEAD></HEAD><BODY><P>In the chart is impossible because have advanced logic</P><P></P><P>In your script, you need to do a pivot table and with a resident load delete those negative values</P></BODY></HTML> Mon, 01 Apr 2013 17:42:21 GMT https://community.qlik.com/t5/QlikView/erasing-rows-in-a-table-chart/m-p/410399#M560773 eddysanchez 2013-04-01T17:42:21Z