Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression to only show current date forward

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

2 Replies

Re: Expression to only show current date forward

HI

Try like this

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

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

Hope that helps

MVP
MVP

Re: Expression to only show current date forward

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.

Community Browser