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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Excel expression **URGENT**

Hi,

Can someone please help me understand what this excel expression does...

=AVERAGE((IF(SUBTOTAL(9,OFFSET($L$5,ROW($L$5:$L$706)-ROW($L$5),0))<>0,SUBTOTAL(9,OFFSET($L$5,ROW($L$5:$L$706)-ROW($L$5),0)))))

Thanks!

10 Replies
Anonymous
Not applicable
Author

it is not giving me any values