How to return records based on two user selected dates (on two different fields)
I am new to Qlik, forgive me if there is an obvious solution. My chart is a table. Each record in the data has an [Issued Date], a [Last Action Date], a [Status], a [Version] and an [Amount]. The user selects a single [Issued Date] and a single [Last Action Date]. The [Status] and [Version] conditional values are hard coded in the query. I want to return records that meet any of the following criteria:
1. ( [Status] = 'Disbursed' ) AND ( [Issued Date] <= ( [Issued Date] the user selects) ) AND ( [Version] = 1 )
OR
2. ( [Status] = 'Cancelled' ) AND ( [Last Action Date] >= ( [Last Action Date] the user selects) ) AND ( [Issued Date] <= ( [Issued Date] the user selects) ) AND ( [Version] = 2 )
OR
3. ( [Status] = 'Stale Date' ) AND ( [Last Action Date] >= ( [Last Action Date] the user selects) ) AND ( [Issued Date] <= ( [Issued Date] the user selects) ) AND ( [Version] = 1 )
For all records that meet the above criteria, I want a detailed report (a table of all the records/fields) and a summary report (a record count and amount total for each of the three statuses.) Currently they are actually two different apps/reports, so that would be fine, I'm assuming it's a bit easier to split them up.