Select only future months

jduenyas — Thu, 24 Mar 2011 23:59:50 GMT

I am trying to show in a chart only values set for future months (projections). Here is the Expression:

Sum ({$<ESTYR={$(=(only(ESTYR)))},ESTMO={">=$(month(now))"}>}SalesAmount)

However I get in return all months not only Mar thorogh Dec as I would exect. ESTMO is numeric and so I believe is Month(now())

Am I doing anything wrong?

Thanks

Josh

Fri, 25 Mar 2011 04:12:48 GMT

hi jduenyas

Use like below..

Month(Today())

Month(Date(Today()))

topic Select only future months in QlikView