For Miguel A. Baeyens

Wed, 18 Nov 2009 21:44:22 GMT

You set your post so that we could not reply...

I use the following to calculate the sales between two dates.

Create 2 variables, vDate1 & vDate2. Set your dates to these variables.

=sum({$<Invoice_Date={">=$(#vDate1) <=$(#vDate2)"}>} sales_val)

For Miguel A. Baeyens

Miguel_Angel_Baeyens — Wed, 18 Nov 2009 22:36:39 GMT

Thanks for your reply Carney.

The question was posted as "Question", so it must be possible to answer. Try again, anyway.

The thing is that one of the dates is in one Field (so I cannot load it in a variable, and that's why I try with (#=Date(Field))). As you can see in my example, I've tried that, I don't get any errors but it doesn't work.

topic For Miguel A. Baeyens in QlikView

For Miguel A. Baeyens

For Miguel A. Baeyens