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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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