Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

3 year average

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????

1 Solution

Accepted Solutions
swuehl
MVP
MVP

The field modifier needs to be used like

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

View solution in original post

2 Replies
swuehl
MVP
MVP

The field modifier needs to be used like

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

View solution in original post

Not applicable
Author

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>