topic Avg for 3 Pivot Table Expressions which are sometimes NULL in QlikView https://community.qlik.com/t5/QlikView/Avg-for-3-Pivot-Table-Expressions-which-are-sometimes-NULL/m-p/795896#M1025621 <HTML><HEAD></HEAD><BODY><P>I am trying to get the average of 3 different expressions on a pivot table. <SPAN style="font-size: 10pt; line-height: 1.5em;">These expressions are sometimes null thus I would want the average of the 2 or 1</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> that aren't null</SPAN></P><P>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.</P><P></P><P></P><P><IMG alt="Eval Comp.JPG" class="image-1 jive-image" src="/legacyfs/online/80624_Eval Comp.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT 2020-11-20T18:02:30Z Avg for 3 Pivot Table Expressions which are sometimes NULL https://community.qlik.com/t5/QlikView/Avg-for-3-Pivot-Table-Expressions-which-are-sometimes-NULL/m-p/795896#M1025621 <HTML><HEAD></HEAD><BODY><P>I am trying to get the average of 3 different expressions on a pivot table. <SPAN style="font-size: 10pt; line-height: 1.5em;">These expressions are sometimes null thus I would want the average of the 2 or 1</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"> that aren't null</SPAN></P><P>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.</P><P></P><P></P><P><IMG alt="Eval Comp.JPG" class="image-1 jive-image" src="/legacyfs/online/80624_Eval Comp.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Avg-for-3-Pivot-Table-Expressions-which-are-sometimes-NULL/m-p/795896#M1025621 2020-11-20T18:02:30Z