your set expression could either
only expand expressions that evaluate to a date format
use the expression search syntax and compare the BOOKINGDATE field with pure numerics to avoid date format issues (I prefer the latter).
Possible solutions could be:
hope this helps
QlikCommunity_Thread_181287.qvw 157.5 K
Thanks - that works perfectly!
Any idea how I can get the Forward position for last year.
Basically for whatever the user selection is for BOOKINGDATE - what was the equivalent revenue (NETNET) we had booked at that same point in time last year.
I tried adapting your expression as below but no luck