topic Use Filters at the Same time as Set Analysis in App Development

Use Filters at the Same time as Set Analysis

CarlyPharma — Sat, 16 Nov 2024 01:19:17 GMT

Hello 🙂

Is it possible to use Filters in combination with set analysis?

I created two states so that I can plot a graph using one parameter and colour the graph using a second parameter:

This works well but now the filters to alter date and batch number do not work.

Does anyone have any suggestions on how to fix this?

Thank you!

Carly

Re: Use Filters at the Same time as Set Analysis

edwin — Fri, 09 Oct 2020 16:39:13 GMT

Set analysis works on top of the filtered data set. it further reduces the filtered data set based on the expression phrases used to limit fields in the set analysis. however, when your set analysis fields overlap with your filters, the set analysis wins out. if you have a filter for PROD = PROD1, PROD2, PROD3, and in your set analysis, you have the clause PROD={'PROD1','PROD'2}, then the filter will be ignored.
i suggest check if you do have overlapping fields in teh filters and set analysis, if you do then you should take a slightly diff approach. depending on your situation, you can create a duplicate filed (named diff) in your load script, say

load ...
PROD,
PROD as %PROD,
....

and you can use one in set analysis and the other in the filters. hope it works for you

Re: Use Filters at the Same time as Set Analysis

CarlyPharma — Fri, 23 Oct 2020 14:53:07 GMT

The issue was solved by changing the alternate state in the filters to match with the line plotted on the graph

Thank you! 🙂