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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
MichalSa
Contributor II
Contributor II

Average of the difference between modified dates with different filters

Hi 

I'm trying to calculate the average of the difference between modified dates with different filters.

The field is called 'Modified date' and is changed when there is a status change

I'm trying to calculate the avg difference of the modified date field when:

1. the status field is equal to "Closed" 

2. the status field is equal to "New" 

Trying to use the below calculation without success:

= avg (({<[Status] = {'Closed'}>} [Modified Date] ) -  {<[Status] = {'New'}>} [Modified Date])

Thanks for your help!

Labels (2)
0 Replies