topic Help with combining existing expression with set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-combining-existing-expression-with-set-analysis/m-p/263422#M1191373 <HTML><HEAD></HEAD><BODY><P>May try this expression :</P><P></P><P></P><P><EM><STRONG>sum({&lt; Cal_Date=,Cal_Week=,Cal_Year=,Cal_DayCount={"&gt;$(=max(Cal_DayCount)-1) &lt;=$(=max(Cal_DayCount)-0)"} , Narrative -= {'WASTAGE','DAMAGED'} &gt;}&nbsp; "StockValue")</STRONG></EM></P></BODY></HTML> Thu, 07 Jul 2011 11:38:16 GMT 2011-07-07T11:38:16Z Help with combining existing expression with set analysis https://community.qlik.com/t5/QlikView/Help-with-combining-existing-expression-with-set-analysis/m-p/263421#M1191372 <HTML><HEAD></HEAD><BODY><P>Hi, i ahve the following expression in my chart:</P><P>sum(if(Narrative&lt;&gt;'WASTAGE'and Narrative&lt;&gt;'DAMAGED',StockValue))</P><P>I need to add in the following set analysis</P><P></P><P>sum({&lt; Cal_Date=,Cal_Week=,Cal_Year=,Cal_DayCount={"&gt;$(=max(Cal_DayCount)-1) &lt;=$(=max(Cal_DayCount)-0)"}&gt;} "StockValue")</P><P></P><P>but i am unsure on how to do it..</P><P>Can someone tell me how to make it a single set analysis expression please?</P></BODY></HTML> Thu, 07 Jul 2011 10:47:31 GMT https://community.qlik.com/t5/QlikView/Help-with-combining-existing-expression-with-set-analysis/m-p/263421#M1191372 hopkinsc 2011-07-07T10:47:31Z Help with combining existing expression with set analysis https://community.qlik.com/t5/QlikView/Help-with-combining-existing-expression-with-set-analysis/m-p/263422#M1191373 <HTML><HEAD></HEAD><BODY><P>May try this expression :</P><P></P><P></P><P><EM><STRONG>sum({&lt; Cal_Date=,Cal_Week=,Cal_Year=,Cal_DayCount={"&gt;$(=max(Cal_DayCount)-1) &lt;=$(=max(Cal_DayCount)-0)"} , Narrative -= {'WASTAGE','DAMAGED'} &gt;}&nbsp; "StockValue")</STRONG></EM></P></BODY></HTML> Thu, 07 Jul 2011 11:38:16 GMT https://community.qlik.com/t5/QlikView/Help-with-combining-existing-expression-with-set-analysis/m-p/263422#M1191373 2011-07-07T11:38:16Z