Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
solintegra
Contributor
Contributor

How I can erase some rows from a pivot table with negatives values

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.

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.

Please If any one, was the similar problem,  I will appreciate very much some tips or help about it. Thanks all.

Qlik Senior Consultant
0 Replies