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: 
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