3 year average

[#1]

I need to add an expression that makes an average over 3 year - something like this:

=count({<year=2010,2011,2012}, items)/3

  But this does´nt work????

[swuehl · Accepted solution]

The field modifier needs to be used like

=count({<year= {2010,2011,2012} >} items) /3

[#3]

Thanx – it works

Med venlig hilsen

Søren Schou

Konsulent

Sektionen for Strategi og Styring

Politigården

1567 København V

tlf. +45 3314 1448

Direkt +45 3621 2331

Lokal. (11) 2331

Fra: swuehl

Sendt: 2. oktober 2013 12:51

Til: Schou, Hans Henrik Søren (SSC009)

Emne: Re: - 3 year average

QlikCommunity<http://community.qlik.com/>

3 year average

reply from swuehl<http://community.qlik.com/people/swuehl?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/399652?et=watches.email.thread#399652>