Use Filters at the Same time as Set Analysis

[CarlyPharma]

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 

[edwin]

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

[CarlyPharma · Accepted solution]

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

Thank you! 🙂