topic A where between two tables in QlikView https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485867#M181559 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="124" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 321px; height: 117px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">n<STRONG>ame</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ticket_number</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>quantity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH></TR><TR><TD style="padding: 2px;">marie</TD><TD style="padding: 2px;">96</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">2013-10-17</TD></TR><TR><TD style="padding: 2px;">steven</TD><TD style="padding: 2px;">96</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">2013-10-17</TD></TR><TR><TD style="padding: 2px;">ann</TD><TD style="padding: 2px;">53</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2013-10-15</TD></TR><TR><TD style="padding: 2px;">josh</TD><TD style="padding: 2px;">88</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">2013-10-10</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 192px; height: 39px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">winner_number</TH></TR><TR><TD style="padding: 2px;">2013-10-17</TD><TD style="padding: 2px;">96</TD></TR><TR><TD style="padding: 2px;">2013-10-15</TD><TD style="padding: 2px;">53</TD></TR><TR><TD style="padding: 2px;">2013-10-10</TD><TD style="padding: 2px;">88</TD></TR></TBODY></TABLE><P></P><P>So I have a ticket system where a person can buy as many as they want, the other table registers the winner number and the date. Is there a way to store in a variable and/or table the sum() of the quantity of winner_number given a date?</P><P></P><P>I have done this easily on mysql (<EM>Select sum(quantity) from buyer where ticket_number=winner_table.winner_number</EM>) but is giving me a hell here because I'm somewhat new.</P><P></P><P>Thanks in advance for your help.</P></BODY></HTML> Thu, 17 Oct 2013 15:15:02 GMT 2013-10-17T15:15:02Z A where between two tables https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485867#M181559 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" height="124" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&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;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid rgb(0, 0, 0); width: 321px; height: 117px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">n<STRONG>ame</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>ticket_number</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>quantity</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH></TR><TR><TD style="padding: 2px;">marie</TD><TD style="padding: 2px;">96</TD><TD style="padding: 2px;">15</TD><TD style="padding: 2px;">2013-10-17</TD></TR><TR><TD style="padding: 2px;">steven</TD><TD style="padding: 2px;">96</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">2013-10-17</TD></TR><TR><TD style="padding: 2px;">ann</TD><TD style="padding: 2px;">53</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">2013-10-15</TD></TR><TR><TD style="padding: 2px;">josh</TD><TD style="padding: 2px;">88</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">2013-10-10</TD></TR></TBODY></TABLE><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 192px; height: 39px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">winner_number</TH></TR><TR><TD style="padding: 2px;">2013-10-17</TD><TD style="padding: 2px;">96</TD></TR><TR><TD style="padding: 2px;">2013-10-15</TD><TD style="padding: 2px;">53</TD></TR><TR><TD style="padding: 2px;">2013-10-10</TD><TD style="padding: 2px;">88</TD></TR></TBODY></TABLE><P></P><P>So I have a ticket system where a person can buy as many as they want, the other table registers the winner number and the date. Is there a way to store in a variable and/or table the sum() of the quantity of winner_number given a date?</P><P></P><P>I have done this easily on mysql (<EM>Select sum(quantity) from buyer where ticket_number=winner_table.winner_number</EM>) but is giving me a hell here because I'm somewhat new.</P><P></P><P>Thanks in advance for your help.</P></BODY></HTML> Thu, 17 Oct 2013 15:15:02 GMT https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485867#M181559 2013-10-17T15:15:02Z Re: A where between two tables https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485868#M181560 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA</P></BODY></HTML> Thu, 17 Oct 2013 15:37:16 GMT https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485868#M181560 MayilVahanan 2013-10-17T15:37:16Z Re: A where between two tables https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485869#M181561 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>It looks like the sum(quantity) as expression will give 20</P><P>Is that what you want?</P><P></P><P>Chris</P></BODY></HTML> Thu, 17 Oct 2013 15:37:55 GMT https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485869#M181561 2013-10-17T15:37:55Z Re: A where between two tables https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485870#M181562 <HTML><HEAD></HEAD><BODY><P>=Sum(quantity)</P></BODY></HTML> Thu, 17 Oct 2013 15:41:42 GMT https://community.qlik.com/t5/QlikView/A-where-between-two-tables/m-p/485870#M181562 preminqlik 2013-10-17T15:41:42Z