Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Date Range Question

I'm relatively new to QV and have searched the discussion topics to try and find an answer to this, but haven't yet stumbled accross anything.

Basically what I need to do is filter a report based on a date selection.  However it is not as simple as that.  What I need, is for the user to be able to select a date, say 1st December 2012, and for the report to show patients who were in the hospital on that date... so where the admission date was less than or equal to 1st December and the discharge date was greater than or equal to 1st December (or blank if they are not yet discharged)....

I can't quite get my head around how to do this.  Im suspecting it might be using a variable, but again I can't quite work out how to do this.

Any help greatly appreciated.

Happy Holidays.