Set analysis with partial selection

[#1]

I have a set anaylsis formula I am working on that has me stumped. Is there a way to write this to ignore all user selections except one field? Below is my formula. The goal is to count all products for a specific month regardless of what the user has selected with the exception of the FILTER_FLAG field, in which case I need to use their selected value.

Count(TOTAL <PRODUCT> {1<Month={"$(=MonthName(vEmergCur))"}, FILTER_FLAG={userselectedvalue}>}MY_ID)

Thanks in advance

Brent

[Oleg_Troyansky · Accepted solution]

I think this is what you are looking for:

Count(TOTAL <PRODUCT> {1<Month={"$(=MonthName(vEmergCur))"}, FILTER_FLAG=P({$} FILTER_FLAG)>}MY_ID)

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[#3]

Thank you Oleg. That seemed to work perfectly! I appreciate your quick and accurate response.