Conditionally hiding data

Tue, 22 Oct 2013 16:16:01 GMT

Hello - I am having trouble coming up with a solution for this need. If you look at the chart below, you will see that "Item 1" has an "Ordered QTY" of 16. We actually have 200 ("Item QTY") of that item. However, showing all 200 in the pivot is not necessary, I only need to show enough quantity to fill the order.

What I'm looking to do is filter rows once the running total of the column "Item QTY" exceeds or meets "Ordered QTY". For the "Item 1" example, I need to show rows 3, 4, and 5. Rows 6,7,8 are not needed since the we have already displayed enough quantity to fill the order.

Any suggestions? I'm guessing it's easier than I'm making it. I'm still trying to get the hang of QlikView.

Thanks in advance,

Tim

topic Conditionally hiding data in QlikView

Conditionally hiding data