topic Input Field in QlikView https://community.qlik.com/t5/QlikView/Input-Field/m-p/372829#M492535 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">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. </SPAN><SPAN style="font-size: 10pt;">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?</SPAN></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13408939873612122" jivemacro_uid="_13408939873612122">=InputAvg(INPUT_SALE_PRICE, '/')</PRE></BODY></HTML> Thu, 28 Jun 2012 14:34:09 GMT 2012-06-28T14:34:09Z Input Field https://community.qlik.com/t5/QlikView/Input-Field/m-p/372829#M492535 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">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. </SPAN><SPAN style="font-size: 10pt;">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?</SPAN></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13408939873612122" jivemacro_uid="_13408939873612122">=InputAvg(INPUT_SALE_PRICE, '/')</PRE></BODY></HTML> Thu, 28 Jun 2012 14:34:09 GMT https://community.qlik.com/t5/QlikView/Input-Field/m-p/372829#M492535 2012-06-28T14:34:09Z