topic Re: How to add average label in QlikView https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82921#M784060 <HTML><HEAD></HEAD><BODY><P>If this is a pivot table just check Show partial sums in presentation tab of that Field CurrentMonth/Year. Then change the Label for totals to Average. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195972_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 11 Mar 2018 06:23:31 GMT vishsaggi 2018-03-11T06:23:31Z How to add average label https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82918#M784057 <HTML><HEAD></HEAD><BODY><P> have calculated the average of rows. How do i add label average in last column after Jan2018?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195967_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82918#M784057 savithri_n_s 2020-11-25T16:16:04Z Re: How to add average label https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82919#M784058 <HTML><HEAD></HEAD><BODY><P>Don't have access to qvw but may be this can work- </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195954_Capture.PNG" style="height: 398px; width: 620px;" /></P></BODY></HTML> Sat, 10 Mar 2018 17:34:01 GMT https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82919#M784058 Digvijay_Singh 2018-03-10T17:34:01Z Re: How to add average label https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82920#M784059 <HTML><HEAD></HEAD><BODY><P>Expression - Label</P></BODY></HTML> Sat, 10 Mar 2018 17:34:04 GMT https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82920#M784059 isingh30 2018-03-10T17:34:04Z Re: How to add average label https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82921#M784060 <HTML><HEAD></HEAD><BODY><P>If this is a pivot table just check Show partial sums in presentation tab of that Field CurrentMonth/Year. Then change the Label for totals to Average. </P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195972_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 11 Mar 2018 06:23:31 GMT https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82921#M784060 vishsaggi 2018-03-11T06:23:31Z Re: How to add average label https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82922#M784061 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195981_Capture.JPG" style="height: auto;" /></P><P>On Presentation tab, you can give label whatever you want for the total</P></BODY></HTML> Sun, 11 Mar 2018 10:23:33 GMT https://community.qlik.com/t5/QlikView/How-to-add-average-label/m-p/82922#M784061 shiveshsingh 2018-03-11T10:23:33Z