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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Average in Script when

I have the below expression but want to add this into the script. How would one write this? I also would like to remove zero values from the average.

Chart Properties Expression below:

Dimensions: Program

Avg({<ENROLLMENT_STATUS = {'Closed'},REASON ={'a','b'}>}DAYS)

Labels (1)
10 Replies
sunny_talwar
MVP
MVP

Check here:

Escape sequences