Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

fasuhaibani
New Contributor III

Filter Result Based On Current Year

Hello Everyone!

I have a table which has few columns such as ID, Date, Expiry Date. So what I am trying to do is to count any row that has expiry date less than current date.

Waiting for your kind response.

1 Reply
MVP
MVP

Re: Filter Result Based On Current Year

May be like this:

Count({<[Expiry Date] = {"$(='<=' & Date(Today(), 'ExpiryDateFormatHere))"}>} ID)