Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

urgent? - not that easy

looking for an avg function which ignores 0s

eg. if teama teamcount=3, teamb teamcount=5, teamc teamcount=0 then avg???(teamcount) should return 4 not 2.666...

4 Replies
MVP
MVP

urgent? - not that easy

Try

=avg( if( teamcount<>0, teamcount) )

Hope this helps,

Stefan

Not applicable

urgent? - not that easy

Using Set Analysis instead:

=avg({<teamcount={"<>0"}>} teamcount)

Not applicable

Re: urgent? - not that easy

thanks for the help

Not applicable

Re: urgent? - not that easy

thanks for your help