Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table e.g.
Engineer | Subject | Created | Days |
Engineer Name | Document explaining how to | 18/04/2011 | 27 |
Engineer Name | report on | 27/07/2011 | 4 |
Engineer Name | Status Refresh | 07/06/2011 | 1 |
The "Days" column is a calculated field
I have created a new input box on the Sheet and assign the value entered to the variable $DaysSinceLastUpdate
I would like to filter the rows displayed in the table so that only the rows with a value in the "Days" column that matches the value in the variable $DaysSinceLastUpdate are displayed
So if I entered "4" in my input box the only row displayed in the table would be
Engineer | Subject | Created | Days |
Engineer Name | report on | 27/07/2011 | 4 |
Hi,
Maybe you can use Set Analysis in your expression:
{$<Days={$(DaysSinceLastUpdate)}>}
Hi Mark,
See attached file for an example of set analysis, like Villafuerte said. Only, I'm doing =sum(...) instead.
Hope this helps,
Siarhei K.
Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.
I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.
Thank you for the template but I'm using the personal edition also and I'm worried if I import any more qvw files that I won't be able to use it any more.
I haven't use set analysis before...I'll pay around with this a bit more and see if I can get it to work.
Oh, no problem.
Here's the expression for a table that I think would do what you need:
=sum({$<Days={'$(DaysSinceLastUpdate)'}>} Days)