topic Re: Multiple conditions in SUM in QlikView https://community.qlik.com/t5/QlikView/Multiple-conditions-in-SUM/m-p/1402167#M800184 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=SUM({&lt;WEEK={'&lt;=$(#vW)'},PERIOD= ,Date = {'$('&lt;=' &amp; =Today())'}&gt;}QTY)</STRONG></P></BODY></HTML> Thu, 30 Nov 2017 17:27:52 GMT Anil_Babu_Samineni 2017-11-30T17:27:52Z Multiple conditions in SUM https://community.qlik.com/t5/QlikView/Multiple-conditions-in-SUM/m-p/1402166#M800183 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I am new to Qlikview and inherited a LOT of reports that I now need to look after.</P><P></P><P>A problem I am having is one where I need an additional filter to the sum</P><P></P><P>The existing expression is:</P><P>=SUM({&lt;WEEK={'&lt;=$(#vW)'},PERIOD=&gt;}QTY)</P><P></P><P>I need to also incorporate an additional filter for a date where future records are loaded so the week and period filters would match but the QTY must not be summed as it is for a future date. I cannot figure out how to incorporate this. Can anyone assist please?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-SUM/m-p/1402166#M800183 qlikviewrmw 2020-11-25T16:16:04Z Re: Multiple conditions in SUM https://community.qlik.com/t5/QlikView/Multiple-conditions-in-SUM/m-p/1402167#M800184 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>=SUM({&lt;WEEK={'&lt;=$(#vW)'},PERIOD= ,Date = {'$('&lt;=' &amp; =Today())'}&gt;}QTY)</STRONG></P></BODY></HTML> Thu, 30 Nov 2017 17:27:52 GMT https://community.qlik.com/t5/QlikView/Multiple-conditions-in-SUM/m-p/1402167#M800184 Anil_Babu_Samineni 2017-11-30T17:27:52Z