topic Re: Need Help in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/792339#M1034851 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 30 Jan 2015 10:28:31 GMT Gysbert_Wassenaar 2015-01-30T10:28:31Z Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/792338#M1034850 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have table A:</P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="394" style="width: 255px; height: 394px;"><TBODY><TR><TD height="20" width="64">Date</TD><TD width="64">Year</TD><TD width="77">Invoice_No</TD><TD width="64">Stock</TD></TR><TR><TD align="right" height="20">20150101</TD><TD align="right">2014</TD><TD align="right">1</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">20150102</TD><TD align="right">2014</TD><TD align="right">2</TD><TD align="right">20</TD></TR><TR><TD align="right" height="20">20150103</TD><TD align="right">2014</TD><TD align="right">3</TD><TD align="right">30</TD></TR><TR><TD align="right" height="20">20140104</TD><TD align="right">2014</TD><TD align="right">4</TD><TD align="right">40</TD></TR><TR><TD align="right" height="20">20140105</TD><TD align="right">2014</TD><TD align="right">5</TD><TD align="right">50</TD></TR><TR><TD align="right" height="20">20140106</TD><TD align="right">2014</TD><TD align="right">6</TD><TD align="right">60</TD></TR><TR><TD align="right" height="20">20140107</TD><TD align="right">2014</TD><TD align="right">7</TD><TD align="right">70</TD></TR><TR><TD align="right" height="20">20140108</TD><TD align="right">2014</TD><TD align="right">8</TD><TD align="right">80</TD></TR><TR><TD align="right" height="20">20140109</TD><TD align="right">2014</TD><TD align="right">9</TD><TD align="right">90</TD></TR><TR><TD align="right" height="20">20140110</TD><TD align="right">2014</TD><TD align="right">10</TD><TD align="right">100</TD></TR><TR><TD align="right" height="20">20140111</TD><TD align="right">2014</TD><TD align="right">11</TD><TD align="right">110</TD></TR><TR><TD align="right" height="20">20140112</TD><TD align="right">2014</TD><TD align="right">12</TD><TD align="right">120</TD></TR><TR><TD align="right" height="20">20140113</TD><TD align="right">2014</TD><TD align="right">13</TD><TD align="right">130</TD></TR><TR><TD align="right" height="20">20140114</TD><TD align="right">2014</TD><TD align="right">14</TD><TD align="right">140</TD></TR></TBODY></TABLE><P></P><P>And table B:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="77"><TBODY><TR><TD height="20" width="77">Invoice_No</TD></TR><TR><TD align="right" height="20">1</TD></TR><TR><TD align="right" height="20">2</TD></TR><TR><TD align="right" height="20">3</TD></TR><TR><TD align="right" height="20">4</TD></TR><TR><TD align="right" height="20">5</TD></TR><TR><TD align="right" height="20">6</TD></TR><TR><TD align="right" height="20">7</TD></TR><TR><TD align="right" height="20">8</TD></TR><TR><TD align="right" height="20">9</TD></TR></TBODY></TABLE><P></P><P></P><P>Now I want when I select year or date I want sum of stock related to table B:450</P><P>and remaining 600 for table a Invoice number</P><P></P><P>Thanks</P></BODY></HTML> Thu, 29 Jan 2015 17:21:04 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/792338#M1034850 Anonymous 2015-01-29T17:21:04Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/792339#M1034851 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 30 Jan 2015 10:28:31 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/792339#M1034851 Gysbert_Wassenaar 2015-01-30T10:28:31Z Re: Need Help https://community.qlik.com/t5/QlikView/Need-Help/m-p/792340#M1034852 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>I have attached file and I want 345 and 456 records only</P><P></P><P>pls help</P></BODY></HTML> Fri, 30 Jan 2015 10:34:30 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/792340#M1034852 Anonymous 2015-01-30T10:34:30Z