topic Re: Set analysis with partial selection in QlikView

Set analysis with partial selection

Wed, 17 Jun 2015 15:02:06 GMT

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

Re: Set analysis with partial selection

Oleg_Troyansky — Wed, 17 Jun 2015 15:05:48 GMT

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

Re: Set analysis with partial selection

Wed, 17 Jun 2015 18:26:03 GMT

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