Category
Report Builder
Filters to apply to all sub-queries from the main query
Answered
Hello, Yellowfin Team,
Is it possible to filter all of my (6 appended sub-queries) by a filter based on the main query? Currently, I am adding the same filter to every sub-query in order to display the data I need.
Thank you very much!
The same question
Hi Mat,
While you will still have to add the filter to each sub-query (often people use sub-queries to apply different filters to the same dataset), you can use the "link to filter" option to have the filter inherit the values of the master query.
In the same drop-down as "greater than", select link to filter, and then specify the parent filter as the filter in the master query.
Let me know if this works for you.
Regards,
Nathan
Hi Mat,
While you will still have to add the filter to each sub-query (often people use sub-queries to apply different filters to the same dataset), you can use the "link to filter" option to have the filter inherit the values of the master query.
In the same drop-down as "greater than", select link to filter, and then specify the parent filter as the filter in the master query.
Let me know if this works for you.
Regards,
Nathan
Hi Nathan,
Thank you very much for the suggestion, works as intended.
Best wishes,Mat
Hi Nathan,
Thank you very much for the suggestion, works as intended.
Best wishes,Mat
Glad to hear it Mat,
I am going to close this case, but let me know if there is anything else we can help with!
Regards,
Nathan
Glad to hear it Mat,
I am going to close this case, but let me know if there is anything else we can help with!
Regards,
Nathan
Replies have been locked on this page!