Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
solintegra
New 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.

Tags (1)
Community Browser