topic Re: Label for totals in QlikView https://community.qlik.com/t5/QlikView/Label-for-totals/m-p/1009479#M468296 <HTML><HEAD></HEAD><BODY><P>You can try:</P><P></P><P>'Avg ' &amp; concat(distinct Year,', ') </P><P></P><P>It would create:</P><P></P><P>Avg 2010,2011,2012 </P><P></P><P>Or try</P><P></P><P>'Avg ' &amp; min(Year) &amp; '-' &amp; max(Year)</P><P></P><P>Avg&nbsp; 2010-2012</P></BODY></HTML> Wed, 09 Sep 2015 21:42:06 GMT JonnyPoole 2015-09-09T21:42:06Z Label for totals https://community.qlik.com/t5/QlikView/Label-for-totals/m-p/1009478#M468295 <HTML><HEAD></HEAD><BODY><P>I have put in a formula for labeling my total (average) of quarters.&nbsp; It is ='Avg '&amp;Year.&nbsp; However if more than one year is selected it doesn't know which year and just puts in the text Avg without the year.&nbsp; What am I doing wrong as I assumed it would know the year the subset relates to?</P><P></P><P><IMG alt="Capture3.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98454_Capture3.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Sep 2015 21:00:00 GMT https://community.qlik.com/t5/QlikView/Label-for-totals/m-p/1009478#M468295 Anonymous 2015-09-09T21:00:00Z Re: Label for totals https://community.qlik.com/t5/QlikView/Label-for-totals/m-p/1009479#M468296 <HTML><HEAD></HEAD><BODY><P>You can try:</P><P></P><P>'Avg ' &amp; concat(distinct Year,', ') </P><P></P><P>It would create:</P><P></P><P>Avg 2010,2011,2012 </P><P></P><P>Or try</P><P></P><P>'Avg ' &amp; min(Year) &amp; '-' &amp; max(Year)</P><P></P><P>Avg&nbsp; 2010-2012</P></BODY></HTML> Wed, 09 Sep 2015 21:42:06 GMT https://community.qlik.com/t5/QlikView/Label-for-totals/m-p/1009479#M468296 JonnyPoole 2015-09-09T21:42:06Z