topic Re: sum with set analysis with different conditions in QlikView https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380902#M142106 <HTML><HEAD></HEAD><BODY><P>thanx, this is what i needed!</P><P></P><P>grtz,</P><P>chris</P></BODY></HTML> Sat, 25 Aug 2012 22:40:19 GMT chriscools 2012-08-25T22:40:19Z sum with set analysis with different conditions https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380900#M142104 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i'm trying to make a tabel with stock per article, but only for certain warehouses.</P><P>my formula is this:</P><P></P><P>sum<SPAN style="font-size: 8pt;"> ({&lt; </SPAN><SPAN style="color: #800000; font-size: 8pt;">WarehouseName</SPAN><SPAN style="font-size: 8pt;"> = {'WHS BE','Kontich'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">StockQty</SPAN><SPAN style="font-size: 8pt;"> ) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">but i need an extra condition, showing me for these warehouses only the locations where LocationFunction=Picking and Bulk.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">how do i include an extra set analysis? or what is the right way to do it?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">and is there a limitation to the conditions you can build in?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">can anybody help me?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">thanx</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Chris</SPAN></P></BODY></HTML> Sat, 25 Aug 2012 18:38:17 GMT https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380900#M142104 chriscools 2012-08-25T18:38:17Z Re: sum with set analysis with different conditions https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380901#M142105 <HTML><HEAD></HEAD><BODY><P>Hi Chris!</P><P></P><P>No, there aren't limitations in the conditions of Set Analysis.</P><P></P><P>Try with:</P><P></P><P>Sum( {&lt;WarehouseName = {"WHS BE", "Konitch"}, LocationFunction = {"Picking","Bulk"}&gt;}StockQty)</P></BODY></HTML> Sat, 25 Aug 2012 21:55:24 GMT https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380901#M142105 sebastiandperei 2012-08-25T21:55:24Z Re: sum with set analysis with different conditions https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380902#M142106 <HTML><HEAD></HEAD><BODY><P>thanx, this is what i needed!</P><P></P><P>grtz,</P><P>chris</P></BODY></HTML> Sat, 25 Aug 2012 22:40:19 GMT https://community.qlik.com/t5/QlikView/sum-with-set-analysis-with-different-conditions/m-p/380902#M142106 chriscools 2012-08-25T22:40:19Z