PSDio IQ - How to build a query to report LYBUNT/SYBUNT results for a specific date range

How to build a query to report LYBUNT/SYBUNT results for a specific date range

This query will give you LYBUNT/SYBUNT results for a specific date range. There are four pictures below to help you build this query: the first two are the columns and the second two are the conditions (with the second picture of conditions being the sub-query).

The query conditions start with a sub-query. The sub-query says "Show me all the families that don't have a pledge for a certain time frame." For example, the sub-query could ask for all the families that haven't given during 2017. The query then could have conditions that would say, "Of those families who haven't given in 2017, show me the families who did give in 2016." 

 

Columns #1
results_1.jpg

 

Columns #2
results_2.jpg

 

Conditions
date_conditions.jpg

 

Sub-query
date_subquery.jpg

 

 

 

Related Articles

How to add, remove, or replace a column

How to add, edit, or remove a condition 

How to build a query reporting LYBUNT/SYBUNT results for specific funds

How to build sub-queries in IQ 

 

 

 Top

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request