Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you Oleg. That seemed to work perfectly! I appreciate your quick and accurate response.