Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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 (3)
0 Replies