Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-10-22 12:16 PM

Conditionally hiding data

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

Capture.PNG.png

175 Views
0 Likes
0 Replies