topic Re: 3 year average in QlikView https://community.qlik.com/t5/QlikView/3-year-average/m-p/501411#M187365 <HTML><HEAD></HEAD><BODY><P>Thanx – it works</P><P></P><P>Med venlig hilsen</P><P></P><P>Søren Schou</P><P>Konsulent</P><P></P><P></P><P>Sektionen for Strategi og Styring</P><P>Politigården</P><P>1567 København V</P><P>tlf. +45 3314 1448</P><P>Direkt +45 3621 2331</P><P>Lokal. (11) 2331</P><P></P><P>Fra: swuehl </P><P>Sendt: 2. oktober 2013 12:51</P><P>Til: Schou, Hans Henrik Søren (SSC009)</P><P>Emne: Re: - 3 year average</P><P></P><P>QlikCommunity&lt;http://community.qlik.com/&gt;</P><P></P><P>3 year average</P><P></P><P>reply from swuehl&lt;http://community.qlik.com/people/swuehl?et=watches.email.thread&gt; in App Development - View the full discussion&lt;http://community.qlik.com/message/399652?et=watches.email.thread#399652&gt;</P></BODY></HTML> Fri, 04 Oct 2013 05:15:14 GMT 2013-10-04T05:15:14Z 3 year average https://community.qlik.com/t5/QlikView/3-year-average/m-p/501409#M187363 <HTML><HEAD></HEAD><BODY><P>I need to add an expression that makes an average over 3 year - something like this:</P><P>=count({&lt;year=2010,2011,2012}, items)/3</P><P><SPAN style="font-size: 8pt;">&nbsp; But this does´nt work????</SPAN></P></BODY></HTML> Wed, 02 Oct 2013 10:48:38 GMT https://community.qlik.com/t5/QlikView/3-year-average/m-p/501409#M187363 2013-10-02T10:48:38Z Re: 3 year average https://community.qlik.com/t5/QlikView/3-year-average/m-p/501410#M187364 <HTML><HEAD></HEAD><BODY><P>The field modifier needs to be used like</P><P></P><P>=count({&lt;year= {2010,2011,2012} &gt;} items) /3</P></BODY></HTML> Wed, 02 Oct 2013 10:50:26 GMT https://community.qlik.com/t5/QlikView/3-year-average/m-p/501410#M187364 swuehl 2013-10-02T10:50:26Z Re: 3 year average https://community.qlik.com/t5/QlikView/3-year-average/m-p/501411#M187365 <HTML><HEAD></HEAD><BODY><P>Thanx – it works</P><P></P><P>Med venlig hilsen</P><P></P><P>Søren Schou</P><P>Konsulent</P><P></P><P></P><P>Sektionen for Strategi og Styring</P><P>Politigården</P><P>1567 København V</P><P>tlf. +45 3314 1448</P><P>Direkt +45 3621 2331</P><P>Lokal. (11) 2331</P><P></P><P>Fra: swuehl </P><P>Sendt: 2. oktober 2013 12:51</P><P>Til: Schou, Hans Henrik Søren (SSC009)</P><P>Emne: Re: - 3 year average</P><P></P><P>QlikCommunity&lt;http://community.qlik.com/&gt;</P><P></P><P>3 year average</P><P></P><P>reply from swuehl&lt;http://community.qlik.com/people/swuehl?et=watches.email.thread&gt; in App Development - View the full discussion&lt;http://community.qlik.com/message/399652?et=watches.email.thread#399652&gt;</P></BODY></HTML> Fri, 04 Oct 2013 05:15:14 GMT https://community.qlik.com/t5/QlikView/3-year-average/m-p/501411#M187365 2013-10-04T05:15:14Z