Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
Contributor III

Straight table, only show field equal or greater than this month?

Hi All,

I have a list of data on a Straight Table, which I need to limit to only show when the date of that item, is equal too or greater than today's month. Is there an expression for this?

Many Thanks

Kozan

3 Replies
sunny_talwar

May be this

Sum({<Date = {"$(='>=' & Date(MonthStart(Today(), 1), 'DateFieldFormatHere'))"}>}Measure)

kfahri342
Contributor III
Contributor III
Author

Thanks for the reply.

Unfortunately, it didn't work - it just kept saying ERROR IN EXPRESSION.

If it help, the column I am trying to filter is called "Target Date" and the format is "MMM-YY"

sunny_talwar

This didn't work?

Sum({<[Target Date] = {"$(='>=' & Date(MonthStart(Today(), 1), 'MMM-YY'))"}>}Measure)