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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read 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)