topic function avg in App Development

topic function avg in App Development https://community.qlik.com/t5/App-Development/function-avg/m-p/1935979#M77694 <P><SPAN>hello</SPAN></P> <P><SPAN>How can I replace the number 149 with a location function?</SPAN></P> <P><SPAN>= count ({<AVGSUB = {"<= <STRONG>149</STRONG>"}>} distinct user unsub) </SPAN></P> <P><SPAN>means:</SPAN></P> <P><SPAN>= count ({<AVGSUB = {"<= (<STRONG>avg(avgsub)</STRONG>)"}>} distinct user unsub) </SPAN></P> Fri, 15 Nov 2024 22:53:00 GMT faezeh 2024-11-15T22:53:00Z function avg https://community.qlik.com/t5/App-Development/function-avg/m-p/1935979#M77694 <P><SPAN>hello</SPAN></P> <P><SPAN>How can I replace the number 149 with a location function?</SPAN></P> <P><SPAN>= count ({<AVGSUB = {"<= <STRONG>149</STRONG>"}>} distinct user unsub) </SPAN></P> <P><SPAN>means:</SPAN></P> <P><SPAN>= count ({<AVGSUB = {"<= (<STRONG>avg(avgsub)</STRONG>)"}>} distinct user unsub) </SPAN></P> Fri, 15 Nov 2024 22:53:00 GMT https://community.qlik.com/t5/App-Development/function-avg/m-p/1935979#M77694 faezeh 2024-11-15T22:53:00Z