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?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful