Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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, '/')
0 Replies