topic dynamic boolean function (set analysis) in QlikView https://community.qlik.com/t5/QlikView/dynamic-boolean-function-set-analysis/m-p/408016#M485918 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>i'm engaged with an idea. I want to dimically compose (set analysis) function.</P><P></P><P>I have medical methods and associated results. What i'm trying to do is, dynamically compose a selection over some methods and certain results wirh boolean conjunction.</P><P></P><P>Let's say, i want to analyse all data related to following selection: </P><P>= (method01 with resultA) and (method02 with resultB) or (method03 with resultA) and ...</P><P></P><P>I thought, i can do this with set analysis. So i defined new field BOOLEAN with Expression "AND", "OR" and try to select $, $1, $2 over fields of methods, results and boolean. But now i stuck...</P><P></P><P>How wolud you implement such a requirement?</P><P></P><P>Thanks for any idea!</P></BODY></HTML> Sat, 30 Mar 2013 13:41:56 GMT damian_spyra 2013-03-30T13:41:56Z dynamic boolean function (set analysis) https://community.qlik.com/t5/QlikView/dynamic-boolean-function-set-analysis/m-p/408016#M485918 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>i'm engaged with an idea. I want to dimically compose (set analysis) function.</P><P></P><P>I have medical methods and associated results. What i'm trying to do is, dynamically compose a selection over some methods and certain results wirh boolean conjunction.</P><P></P><P>Let's say, i want to analyse all data related to following selection: </P><P>= (method01 with resultA) and (method02 with resultB) or (method03 with resultA) and ...</P><P></P><P>I thought, i can do this with set analysis. So i defined new field BOOLEAN with Expression "AND", "OR" and try to select $, $1, $2 over fields of methods, results and boolean. But now i stuck...</P><P></P><P>How wolud you implement such a requirement?</P><P></P><P>Thanks for any idea!</P></BODY></HTML> Sat, 30 Mar 2013 13:41:56 GMT https://community.qlik.com/t5/QlikView/dynamic-boolean-function-set-analysis/m-p/408016#M485918 damian_spyra 2013-03-30T13:41:56Z Re: dynamic boolean function (set analysis) https://community.qlik.com/t5/QlikView/dynamic-boolean-function-set-analysis/m-p/408017#M485919 <HTML><HEAD></HEAD><BODY><P>sure</P><P></P><P>this is what you do:</P><P>sum({$&lt;(method01 = {"resultA"} &gt; * ( &lt;method02= {"resultB"}&gt; + &lt;method03= {"resultA"}&gt;)}&nbsp; Sales)</P><P></P><P>Benji</P></BODY></HTML> Sun, 31 Mar 2013 08:58:22 GMT https://community.qlik.com/t5/QlikView/dynamic-boolean-function-set-analysis/m-p/408017#M485919 2013-03-31T08:58:22Z