view data in table based on its age

[#1]

Hello

I'm trying to add method into my Qlikview app of filtering data held within a table based on how long its been held open.  We have a field called "Date Requested" and want users to be able to see all records logged for defined time period:

0-4 Weeks

4-8 Weeks

8-12 Weeks etc.

I've used variables to simply count the number of jobs in these dates ranges which are,

vWIP<4Weeks:

count(DISTINCT{<status_cat={open},probtype_cat={reactive}>} if(vToday-[Date Requested]<=28, [Work Request Code]))

vWIP4-8Weeks:

count(DISTINCT{<status_cat={open},probtype_cat={reactive}>} if(vToday-[Date Requested]>28 and vToday-[Date Requested]<=56, [Work Request Code]))

And these work fine to give give a total number of jobs which fall within these timeframes.  But I'm finding it a little harder to use the same variables to filter the actual records in the table.  Can I use these same variables for this of do I need something else?

What I'm trying to set up is a Button, with an action.  So far I've tried the "Select in Field" action with [Date Requested] as the field and then trying to use the variables in the search string, but to no success so far.

Can anyone help?

[#2]

it strange that as I'd expect same behaviour on all records but is actually only a few very old ones that display with decimals values showing, and when I filter out completed work, to show only current jobs, which is all we need to see anyway, it all displays ok.

so happy with how it works at this stage

Thanks for the help