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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Input Field

I am trying to find parts that have no sales for the last 12 months. I have all of the columns working correctly except for the input field that is in the table. The issue with the input field is that it's going to try to average the inputted value across all invoice line items and there aren't any. This in turns returns all rows and not just the ones with no sales. Is there a way to just have the input field show up for the parts with no sales?

=InputAvg(INPUT_SALE_PRICE, '/')
Labels (1)
0 Replies