Multiple conditions in SUM

[qlikviewrmw]

Good day

I am new to Qlikview and inherited a LOT of reports that I now need to look after.

A problem I am having is one where I need an additional filter to the sum

The existing expression is:

=SUM({<WEEK={'<=$(#vW)'},PERIOD=>}QTY)

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?

[Anil_Babu_Samineni]

May be this?

=SUM({<WEEK={'<=$(#vW)'},PERIOD= ,Date = {'$('<=' & =Today())'}>}QTY)