Text button with count which opens a new sheet with filtered results

[martin_hamilton]

@I have a Text Object which is performing a COUNT of records which when selected opens another sheet. I want to filter the next sheet of results based on the COUNT records. I thought about using a sheet action such as Select In Field but have no idea how to apply the search filter using the records i have counted.

My Text Object looks like this:

=Count({<Sub_Contract_End_Date={"$(='>=' & Date(Today(), 'DD/MM/YYYY') & '<=' & Date(Today()+30, 'DD/MM/YYYY'))"}>} Distinct Sub_Number)

Thanks

Martin

[martin_hamilton]

Exactly what I was looking for! Thank You!

[sunny_talwar · Accepted solution]

Awesome, I am glad we were able to get what you wanted. I suggest marking the correct response so that other people can get to the correct information quickly.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny