Qlik Sense set analysis how to filter a row with 2 combined conditions

[Rafgiordy80]

Hi All,

i have a request that i'm not able to implement.

I have the following AVG measure with a series of filters included in set analysis:

AVG({<[L2_ft_cumulative_trend_defect.WINDOW_DATE]={">=$(V_MinDate)<=$(V_MaxDate)"},
                RELEASE_END_DATE={">=$(V_MinDate)<=$(V_MaxDate)"},
               DETECTED_ON_DATE={">=$(V_MinDate1YB)"},
               L2_ft_cumulative_trend_defect.CLOSING_DATE={">$(V_MinDate)"}>}
[L2_ft_cumulative_trend_defect.AGEING_CORB]/86400)

Now i have to change only the condition in bold in this way:  i have to exclude the rows which have at the same time the fields

"DETECTED_ON_DATE < $(V_MinDate) and L2_ft_cumulative_trend_defect.CLOSING_DATE > $(V_MaxDate)"

I have tried with P() or E() function or +* operators but i receive always errors on set modifier expression.

Could someone please help me to understand which is the right formula?

Thanks a lot,

Raffaello.

[Rafgiordy80]

Can anyone tell me how i could solve?