Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewrmw
Contributor II
Contributor II

Multiple conditions in SUM

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?

1 Reply
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)