Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)