Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Average over last 90 days

I am attempting show an average for the last 90 days in a chart.  I have tried the expression Avg({$<DateNeo={">$(=Today() - 90)"}>} Result), but it returns no results.  If I change the greater than symbol to an equal symbol, as in Avg({$<DateNeo={"=$(=Today() - 90)"}>} Result), it returns back a result.

What needs to be changed to allow this to work?

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

{$<DateNeo={">$(=Date(Today() - 90))"}>}

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

{$<DateNeo={">$(=Date(Today() - 90))"}>}

HIC

Not applicable
Author

Thank you!  I would not have thought there would be a need to convert to date.