Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
first let me give you a tip about this forum - when you add a secondary comment, like you did here, it looks to people like the questions was already answered, and most experts will simply ignore the question, so you actually decrease your chances for a timely resolution... Just stay patient, someone will answer, especially if you formulate your issue in the best possible way.
Now, to your specific questions...
1. Your first table is not a Straight Table, but rather a Table Box. There is very little you can do to limit the contents of the Table Box. You should really convert it into a Straight Table and then use Set Analysis in your expression in order to limit the content. I'll explain that in a moment.
2. In order to hide the Expression (for both tables), open the Properties>Presentation, highlight the Column that contains the Expression in the list, and check the box Hide Column.
3. Now, to the question of limiting the content in the first Straight Table. If I understand your logic correctly, you want to show Closed entries by the default, and switch to Open entries only if Open was selected in the trend chart, right? I'd formulate it like this (I'm using simplified field names in my example, you'll need to formulate it correctly for your data):
IF( only(Status) = 'Open',
sum( {<Status = 'Open'>} 1)
, // ELSE
sum({<Status='Close'>} 1)
)
This Set Analysis expression will select only Open entries when the status Open is selected, or only Closed Entries when either Close is selected or no status selection was made (that's how I understood your initial requirement.
Check out my new book QlikView Your Business. In the book, I'm describing in detail how to use Set Analysis for a variety of analytical needs.
cheers,
Oleg Troyansky
