topic Re: Date conditional sum in QlikView

Date conditional sum

Mon, 29 Sep 2014 15:56:42 GMT

I have a series of values (order qty) and a series of dates (Last Ship Date). I only want to add values where the date is greater than today. I currently have this set-up in a pivot table using years and months as the groupinngs. This is the conditional statement that I am using in the expression: [Last Ship Date]>>Today. This is the expression: sum([order qty])

I want to do this without putting a filter on entire sheet. Any recommendations?

Re: Date conditional sum

Anonymous — Mon, 29 Sep 2014 16:01:31 GMT

try

sum({<[Last Ship Date]={'>$()=today()'}>}[order qty])

Re: Date conditional sum

MarcoWedel — Mon, 29 Sep 2014 16:10:19 GMT

Hi,

you could use this expression:

=Sum({$<[Last Ship Date]={">$(=Today())"}>} [order qty])

hope this helps

regards

Marco