topic How I can delete some rows in a pivot table that has negatives expressions in Water Cooler https://community.qlik.com/t5/Water-Cooler/How-I-can-delete-some-rows-in-a-pivot-table-that-has-negatives/m-p/562287#M2235 <HTML><HEAD></HEAD><BODY><P>Hi all, I have been a lot of time trying resolving an Qlikview's issue with a Macros and Qlikview's Script when you need delete rows from a pivot tables depending of some conditions, but it has been very complicated. I've some problems to find the best form to delete any rows in a pivot table when one of his expression likes an amount are negative values, so I need concatenate this rows with the next rows in order until the sum(amount) will be positive and delete the rows that I wont in my pivot table.</P><P>I'm attaching an excel instance with a simple exemple with the first original sheet and then the second one with de correct sheet that I need take as a final sheet.</P><P>Please If any one, was the similar problem,&nbsp; I will appreciate very much some tips or help about it. Thanks all.</P></BODY></HTML> Tue, 15 Oct 2013 18:52:02 GMT solintegra 2013-10-15T18:52:02Z How I can delete some rows in a pivot table that has negatives expressions https://community.qlik.com/t5/Water-Cooler/How-I-can-delete-some-rows-in-a-pivot-table-that-has-negatives/m-p/562287#M2235 <HTML><HEAD></HEAD><BODY><P>Hi all, I have been a lot of time trying resolving an Qlikview's issue with a Macros and Qlikview's Script when you need delete rows from a pivot tables depending of some conditions, but it has been very complicated. I've some problems to find the best form to delete any rows in a pivot table when one of his expression likes an amount are negative values, so I need concatenate this rows with the next rows in order until the sum(amount) will be positive and delete the rows that I wont in my pivot table.</P><P>I'm attaching an excel instance with a simple exemple with the first original sheet and then the second one with de correct sheet that I need take as a final sheet.</P><P>Please If any one, was the similar problem,&nbsp; I will appreciate very much some tips or help about it. Thanks all.</P></BODY></HTML> Tue, 15 Oct 2013 18:52:02 GMT https://community.qlik.com/t5/Water-Cooler/How-I-can-delete-some-rows-in-a-pivot-table-that-has-negatives/m-p/562287#M2235 solintegra 2013-10-15T18:52:02Z