Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avg for 3 Pivot Table Expressions which are sometimes NULL

I am trying to get the average of 3 different expressions on a pivot table. These expressions are sometimes null thus I would want the average of the 2 or 1 that aren't null

Below there is a picture of the fields I am looking to get the average of. These fields change depending on the person I am looking at.

Eval Comp.JPG

0 Replies