Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis in Expression to show open tickets 60 days or greater

Hello,

I want to create an expression showing my open tickets that have been open for greater than or equal to 60 days.
My Date field is Date_Created. With the following expression my result comes back as '0'

=Count({<Date_Created={">=$(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Try

=Count({<Date_Created={">=$(=Date(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Try

=Count({<Date_Created={">=$(=Date(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)

Regards,

Antonio

sunny_talwar

Or this:

=Count({<Date_Created={"$(='>=' & Max(Date_Created)-60))"}, State-={'Closed'}>}Incident#)