topic Set analysis -- can't get it working for this situation ... in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-can-t-get-it-working-for-this-situation/m-p/163108#M36333 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have the following calculation which I want to translate into a set analysis expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />count( distinct if (SO.SOkind = 'PNP' and (SO.Status = 'Ready' or SO.Status = 'Booked'), SOnr) )<BR /></PRE><BR /><BR /> <P></P><P>I thought this should do the trick ... but I get nothing showed:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />count( {&lt;SO.SOkind = {'PNP'}, SO.Status = {'Ready','Booked'} &gt;} distinct SOnr )<BR /></PRE><BR /><BR /> <P>Does anyone see what I'm doing wrong here??</P><P></P><P>thx</P></BODY></HTML> Tue, 17 Aug 2010 07:56:44 GMT Anonymous 2010-08-17T07:56:44Z Set analysis -- can't get it working for this situation ... https://community.qlik.com/t5/QlikView/Set-analysis-can-t-get-it-working-for-this-situation/m-p/163108#M36333 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have the following calculation which I want to translate into a set analysis expression:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />count( distinct if (SO.SOkind = 'PNP' and (SO.Status = 'Ready' or SO.Status = 'Booked'), SOnr) )<BR /></PRE><BR /><BR /> <P></P><P>I thought this should do the trick ... but I get nothing showed:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />count( {&lt;SO.SOkind = {'PNP'}, SO.Status = {'Ready','Booked'} &gt;} distinct SOnr )<BR /></PRE><BR /><BR /> <P>Does anyone see what I'm doing wrong here??</P><P></P><P>thx</P></BODY></HTML> Tue, 17 Aug 2010 07:56:44 GMT https://community.qlik.com/t5/QlikView/Set-analysis-can-t-get-it-working-for-this-situation/m-p/163108#M36333 Anonymous 2010-08-17T07:56:44Z Set analysis -- can't get it working for this situation ... https://community.qlik.com/t5/QlikView/Set-analysis-can-t-get-it-working-for-this-situation/m-p/163109#M36334 <HTML><HEAD></HEAD><BODY><P>Strangely enough I saved the document, reopend the document ... and now it seems to work.</P><P></P></BODY></HTML> Tue, 17 Aug 2010 08:08:36 GMT https://community.qlik.com/t5/QlikView/Set-analysis-can-t-get-it-working-for-this-situation/m-p/163109#M36334 Anonymous 2010-08-17T08:08:36Z