Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kfahri342
New 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

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

May be this

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

kfahri342
New Contributor III

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

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"

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

This didn't work?

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