topic Re: Sum function with 2 Conditions in QlikView https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065600#M641585 <HTML><HEAD></HEAD><BODY><P>You don't need a dollar sign expansion for a constant value.</P><P></P><P>Try</P><P></P><P>sum({&lt;[Country_Code]={'7'}<STRONG>, [Warehouse_Code] = {'A1'}</STRONG> &gt;} [Available_Qty])</P></BODY></HTML> Sun, 07 Feb 2016 12:05:52 GMT swuehl 2016-02-07T12:05:52Z Sum function with 2 Conditions https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065599#M641584 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I've got this sum function that gives me the total of Available_Qty where Country_Code is 7</P><P></P><P>sum({&lt;[Country_Code]={'$(=7)'}&gt;} [Available_Qty]) </P><P></P><P>I want to add one more condition into this</P><P></P><P>"and where Warehouse_Code is A1"</P><P></P><P>Can anyone help me adding this into the function?</P><P></P><P>thanks</P><P>MT</P></BODY></HTML> Sun, 07 Feb 2016 11:24:32 GMT https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065599#M641584 london1980 2016-02-07T11:24:32Z Re: Sum function with 2 Conditions https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065600#M641585 <HTML><HEAD></HEAD><BODY><P>You don't need a dollar sign expansion for a constant value.</P><P></P><P>Try</P><P></P><P>sum({&lt;[Country_Code]={'7'}<STRONG>, [Warehouse_Code] = {'A1'}</STRONG> &gt;} [Available_Qty])</P></BODY></HTML> Sun, 07 Feb 2016 12:05:52 GMT https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065600#M641585 swuehl 2016-02-07T12:05:52Z Re: Sum function with 2 Conditions https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065601#M641586 <HTML><HEAD></HEAD><BODY><P>Works beautifully, many thanks!</P></BODY></HTML> Sun, 07 Feb 2016 12:16:12 GMT https://community.qlik.com/t5/QlikView/Sum-function-with-2-Conditions/m-p/1065601#M641586 london1980 2016-02-07T12:16:12Z