topic Need help with the expression for calculating average in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-the-expression-for-calculating-average/m-p/330147#M492439 <HTML><HEAD></HEAD><BODY><P>i have year 2011, 2012,2013, but this is fiscal year data ( 2011-2012), (2012-2013)</P><P></P><P>now i need to calculate the 2 yr avergae for a selected week</P><P></P><P>count(disctinct (year) =3&nbsp; but i need 2 here if i subtact the vaule using -1 then if user selects single year whole vaule is 0</P><P></P><P>how to write a expression for this ?</P><P></P><P>i need a expression some what like this</P><P></P><P>(sum( max( week) + sum( max(week-52))/count(max(week) + count(max(week-52))</P><P></P><P> here (week-52) is the previous week but count(max(week) is showing null</P></BODY></HTML> Mon, 02 Jul 2012 21:03:56 GMT Anonymous 2012-07-02T21:03:56Z Need help with the expression for calculating average https://community.qlik.com/t5/QlikView/Need-help-with-the-expression-for-calculating-average/m-p/330147#M492439 <HTML><HEAD></HEAD><BODY><P>i have year 2011, 2012,2013, but this is fiscal year data ( 2011-2012), (2012-2013)</P><P></P><P>now i need to calculate the 2 yr avergae for a selected week</P><P></P><P>count(disctinct (year) =3&nbsp; but i need 2 here if i subtact the vaule using -1 then if user selects single year whole vaule is 0</P><P></P><P>how to write a expression for this ?</P><P></P><P>i need a expression some what like this</P><P></P><P>(sum( max( week) + sum( max(week-52))/count(max(week) + count(max(week-52))</P><P></P><P> here (week-52) is the previous week but count(max(week) is showing null</P></BODY></HTML> Mon, 02 Jul 2012 21:03:56 GMT https://community.qlik.com/t5/QlikView/Need-help-with-the-expression-for-calculating-average/m-p/330147#M492439 Anonymous 2012-07-02T21:03:56Z