topic Re: Expression to only show current date forward in QlikView

Expression to only show current date forward

Mon, 15 Oct 2012 16:43:40 GMT

How would I write an expression to only show data from current date forward on field 'Path_Start_Date'?

MayilVahanan — Mon, 15 Oct 2012 16:49:41 GMT

Try like this

=sum({<Date = {'>=$(=Min(Date))<=$(=Today())'}>}Sales)

Calculate values From today to minimum date as per selection..

Hope that helps

johnw — Mon, 15 Oct 2012 20:23:46 GMT

Another possibility is adding a flag to your calendar:

if(Path_Start_Date>=today(),'Y') as Current_Date_Forward,

And doing this:

count({<Current_Date_Forward={'Y'}>} Bookings)

It should be slightly faster to process, and may be easier for some people to understand.