topic Search string with variables/functions in QlikView https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231875#M83547 <HTML><HEAD></HEAD><BODY><P>Yes that was exactly what i wanted thank you <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Fri, 08 Oct 2010 09:22:21 GMT 2010-10-08T09:22:21Z Search string with variables/functions https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231873#M83545 <HTML><HEAD></HEAD><BODY><P>Is it possible to make a selection based on a function or a calculation in a variable?</P><P>lite: &lt; avg(salesid) ?</P></BODY></HTML> Fri, 08 Oct 2010 08:14:18 GMT https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231873#M83545 2010-10-08T08:14:18Z Search string with variables/functions https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231874#M83546 <HTML><HEAD></HEAD><BODY><P>It is possible,</P><P>You can create a new variable in the Settings menu, Variable Overview, add a new one, say, vTotalCustNo</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=COUNT(DISTINCT CUSTOMER_ID)</PRE></BLOCKQUOTE><BR /><BR /> <P>And then get it</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">$(vTotalCustNo)</PRE></BLOCKQUOTE><BR /><BR /> <P>Is that what you mean?</P></BODY></HTML> Fri, 08 Oct 2010 08:51:55 GMT https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231874#M83546 Miguel_Angel_Baeyens 2010-10-08T08:51:55Z Search string with variables/functions https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231875#M83547 <HTML><HEAD></HEAD><BODY><P>Yes that was exactly what i wanted thank you <IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Fri, 08 Oct 2010 09:22:21 GMT https://community.qlik.com/t5/QlikView/Search-string-with-variables-functions/m-p/231875#M83547 2010-10-08T09:22:21Z