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?
