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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

May be like this:

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