Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Select only future months

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



1 Reply
Not applicable

hi jduenyas

Use like below..

Month(Today())

or

Month(Date(Today()))