Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master III
Partner - Master III

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

It might help.

sunny_talwar

May be like this:

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