topic Re: Input box values reflect on a table in QlikView https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760319#M270539 <HTML><HEAD></HEAD><BODY><P>Thanks for the help</P><P></P><P>but balance is my expression not a field. </P></BODY></HTML> Mon, 09 Mar 2015 07:07:12 GMT 2015-03-09T07:07:12Z Input box values reflect on a table https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760317#M270537 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a input box and a pivot table, when i input the value in text box i want only the results of the specific value like</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 296pt; border-collapse: collapse;" width="392"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: whitesmoke; width: 74pt; height: 12.75pt; border: gainsboro 0.5pt solid;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">Date</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 74pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">Deposit</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 74pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">Withdrawl</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 74pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="98"><STRONG style="color: #333333; font-family: Tahoma;">Balance</STRONG></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">08-08-2012</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">15-08-2012</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">07-02-2013</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">15-02-2013</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">3000</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">06-06-2014</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">14400</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">14400</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">04-09-2014</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">4500</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">18900</SPAN></TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">16-12-2014</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">4500</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">0</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Tahoma; color: #333333;">23400</SPAN></TD></TR></TBODY></TABLE><P></P><P>input box</P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 162px; BORDER-COLLAPSE: collapse;"><TBODY><TR style="height: 12.75pt;"><TD height="17" style="background-color: transparent; width: 74pt; height: 12.75pt; border: #f0f0f0;" width="98"><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="WIDTH: 162px; BORDER-COLLAPSE: collapse;"><COLGROUP> <COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;" width="98" /> <COL style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR style="height: 13.5pt;"><TD class="xl65" height="18" style="border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; background-color: transparent; width: 74pt; height: 13.5pt; border-top: windowtext 1pt solid; border-right: #f0f0f0;" width="98">Balance</TD><TD align="right" class="xl66" style="border-bottom: windowtext 1pt solid; border-left: #f0f0f0; background-color: transparent; width: 48pt; border-top: windowtext 1pt solid; border-right: windowtext 1pt solid;" width="64">3000</TD></TR></TBODY></TABLE></TD><TD align="right" style="background-color: transparent; width: 48pt; border: #f0f0f0;" width="64"></TD></TR></TBODY></TABLE><P>when i input the value in the text box,the table shows only that value like when i insert 3000 it shows 3000 and when i insert in the text box &gt;3000 it shows the amount</P><P>deposit,withdrawal,balance is my expression</P></BODY></HTML> Sat, 07 Mar 2015 09:45:02 GMT https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760317#M270537 2015-03-07T09:45:02Z Re: Input box values reflect on a table https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760318#M270538 <HTML><HEAD></HEAD><BODY><P>How about using a Search Object on Balance ?</P></BODY></HTML> Sat, 07 Mar 2015 10:54:41 GMT https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760318#M270538 Anonymous 2015-03-07T10:54:41Z Re: Input box values reflect on a table https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760319#M270539 <HTML><HEAD></HEAD><BODY><P>Thanks for the help</P><P></P><P>but balance is my expression not a field. </P></BODY></HTML> Mon, 09 Mar 2015 07:07:12 GMT https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760319#M270539 2015-03-09T07:07:12Z Re: Input box values reflect on a table https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760320#M270540 <HTML><HEAD></HEAD><BODY><P>Can you post an example qvw please?</P><P></P><P>Andy</P></BODY></HTML> Mon, 09 Mar 2015 11:08:50 GMT https://community.qlik.com/t5/QlikView/Input-box-values-reflect-on-a-table/m-p/760320#M270540 awhitfield 2015-03-09T11:08:50Z