Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

average function excluding zero fields

I want to display an average setup time for machines, however some days some machines don't have a setup, so the setup time is zero for those days. How can I exclude this data?

2 Replies
shraddha_g
Honored Contributor III

Re: average function excluding zero fields

From Add-ons Section  of chart uncheck show zero values.

It might help.

Re: average function excluding zero fields

May be like this:

Avg({<Date = {"=Sum(Setup) <> 0"}>}Setup)

Community Browser