Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Honored Contributor III

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

Try

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

Regards,

Antonio

2 Replies
antoniotiman
Honored Contributor III

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

Try

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

Regards,

Antonio

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

Or this:

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

Community Browser