Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
WildCat
Contributor II
Contributor II

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.

Any suggestions greatly appreciated! Thank you.

Labels (1)
0 Replies