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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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