topic variable applied to search on express in QlikView https://community.qlik.com/t5/QlikView/variable-applied-to-search-on-express/m-p/479452#M179123 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a straight table with this structure</P><P></P><P>Salesrep&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(SalesAmt)&nbsp;&nbsp;&nbsp; </P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 10000</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20000</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 30000</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 15000</P><P></P><P></P><P>I checked Searchable On presentation tab for Sum(SalesAmt)</P><P>when I click on the search button and key in&nbsp; &gt;10000&lt;30000<BR />the record of B, D will be shown,</P><P></P><P>now, i want to replace this by input box, </P><P>anyone knows how to do it? (I want to make sure the table will calculate only when the variable is input, since the table is large)</P><P>Thx!</P></BODY></HTML> Tue, 05 Nov 2013 03:19:09 GMT 2013-11-05T03:19:09Z variable applied to search on express https://community.qlik.com/t5/QlikView/variable-applied-to-search-on-express/m-p/479452#M179123 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have a straight table with this structure</P><P></P><P>Salesrep&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(SalesAmt)&nbsp;&nbsp;&nbsp; </P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 10000</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 20000</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 30000</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp; 15000</P><P></P><P></P><P>I checked Searchable On presentation tab for Sum(SalesAmt)</P><P>when I click on the search button and key in&nbsp; &gt;10000&lt;30000<BR />the record of B, D will be shown,</P><P></P><P>now, i want to replace this by input box, </P><P>anyone knows how to do it? (I want to make sure the table will calculate only when the variable is input, since the table is large)</P><P>Thx!</P></BODY></HTML> Tue, 05 Nov 2013 03:19:09 GMT https://community.qlik.com/t5/QlikView/variable-applied-to-search-on-express/m-p/479452#M179123 2013-11-05T03:19:09Z Re: variable applied to search on express https://community.qlik.com/t5/QlikView/variable-applied-to-search-on-express/m-p/479453#M179124 <HTML><HEAD></HEAD><BODY><P>Please find the sample qvw attached</P></BODY></HTML> Tue, 05 Nov 2013 05:04:16 GMT https://community.qlik.com/t5/QlikView/variable-applied-to-search-on-express/m-p/479453#M179124 tresB 2013-11-05T05:04:16Z