topic Re: Value of an expression is 0 while using a cutofdate in QlikView

Value of an expression is 0 while using a cutofdate

Anonymous — Wed, 19 Aug 2015 15:13:58 GMT

Hi,

I have the below expression where am getting value 0

=sum({<System={'TI'},[Guarantee Flag] = {'Y'},[Hotel Travel Year] = {$(=Max([Hotel Travel Year])-1)},

BookingDate={"<= $(vTIALGPYCutOfDate)"}>}RoomNightsSold)

i see the issue is with BookingDate={"<= $(vTIALGPYCutOfDate)"}

Variable vTIALGPYCutOfDate = =AddMonths(weekend(date(max(BookingDate)),-1),-12) i.e., 8/9/2014

can someone please help me understand what the issue is?

Thanks!

sunny_talwar — Wed, 19 Aug 2015 15:26:27 GMT

What format is your BookingDate? Does it have the same format as your variable?

Just so we know 8/9/2014 is -> D/M/YYYY or M/D/YYYY?

Anonymous — Wed, 19 Aug 2015 15:37:11 GMT

BookingDate format is M/D/YYYY

sunny_talwar — Wed, 19 Aug 2015 15:41:37 GMT

Not sure if that changes anything, but try and remove the space between <= and the variable:

=Sum({<System={'TI'}, [Guarantee Flag] = {'Y'},[Hotel Travel Year] = {$(=Max([Hotel Travel Year])-1)},

BookingDate={"<=$(vTIALGPYCutOfDate)"}>} RoomNightsSold)

Anonymous — Wed, 19 Aug 2015 15:47:55 GMT

Hello, can you share your application to take a look? Having everything set to show the current error