topic help with set expression please in QlikView https://community.qlik.com/t5/QlikView/help-with-set-expression-please/m-p/179803#M46485 <HTML><HEAD></HEAD><BODY><P>This set function is supposed to sum price*Qty for current Financial Week's (FWeek). FWeek is a field in a list Box That can filter more than one week. the set Calc works when filtered to current week but not more than 1 Week.</P><P>How does it need to change to sum up ALL selected Weeks ?</P><P><BR />sum({1&lt;FWeek = {$(=FWeek)} } &gt;} (PLU_PRICE*QUANTITY))</P><P></P><P>ColinR</P><P></P><BR /><BR /></BODY></HTML> Tue, 08 Dec 2009 22:19:20 GMT 2009-12-08T22:19:20Z help with set expression please https://community.qlik.com/t5/QlikView/help-with-set-expression-please/m-p/179803#M46485 <HTML><HEAD></HEAD><BODY><P>This set function is supposed to sum price*Qty for current Financial Week's (FWeek). FWeek is a field in a list Box That can filter more than one week. the set Calc works when filtered to current week but not more than 1 Week.</P><P>How does it need to change to sum up ALL selected Weeks ?</P><P><BR />sum({1&lt;FWeek = {$(=FWeek)} } &gt;} (PLU_PRICE*QUANTITY))</P><P></P><P>ColinR</P><P></P><BR /><BR /></BODY></HTML> Tue, 08 Dec 2009 22:19:20 GMT https://community.qlik.com/t5/QlikView/help-with-set-expression-please/m-p/179803#M46485 2009-12-08T22:19:20Z help with set expression please https://community.qlik.com/t5/QlikView/help-with-set-expression-please/m-p/179804#M46486 <HTML><HEAD></HEAD><BODY><P>Duplicate Post, Appologies to All please ignore</P><P>(Post timed Out so re-posted)</P><P></P><P></P></BODY></HTML> Tue, 08 Dec 2009 22:25:23 GMT https://community.qlik.com/t5/QlikView/help-with-set-expression-please/m-p/179804#M46486 2009-12-08T22:25:23Z