topic How to calucalte the value using the range in QlikView https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187257#M885548 <HTML><HEAD></HEAD><BODY><P>Hi techi i am new to qlikview</P><P>i have two table </P><P></P><P>Table1:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="156"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="92">Quantity Sold</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD></TR><TR><TD height="20">A</TD><TD align="right">10</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD></TR><TR><TD height="20">B</TD><TD align="right">5</TD></TR><TR><TD height="20">B</TD><TD align="right">10</TD></TR><TR><TD height="20">B</TD><TD align="right">5</TD></TR></TBODY></TABLE><P></P><P>Table 2:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="64">Start</TD><TD width="64">End</TD><TD width="64">Price</TD></TR><TR><TD height="20">A</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">100</TD></TR><TR><TD height="20">A</TD><TD align="right">4</TD><TD align="right">15</TD><TD align="right">110</TD></TR><TR><TD height="20">A</TD><TD align="right">16</TD><TD align="right">30</TD><TD align="right">120</TD></TR><TR><TD height="20">B</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">160</TD></TR><TR><TD height="20">B</TD><TD align="right">4</TD><TD align="right">15</TD><TD align="right">200</TD></TR><TR><TD height="20">B</TD><TD align="right">16</TD><TD align="right">30</TD><TD align="right">210</TD></TR></TBODY></TABLE><P></P><P>and my output should be like this</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 220px;"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="92">Quantity Sold</TD><TD width="64">Price</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD><TD align="right">520</TD></TR><TR><TD height="20">A</TD><TD align="right">10</TD><TD align="right">1100</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD><TD align="right">600</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">This is how i am calculating first 5 quantity sold the total price is 520rs</SPAN></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';">(3*100)+(2*110) = 520</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to calucalte the value using the range https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187257#M885548 <HTML><HEAD></HEAD><BODY><P>Hi techi i am new to qlikview</P><P>i have two table </P><P></P><P>Table1:</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="156"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="92">Quantity Sold</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD></TR><TR><TD height="20">A</TD><TD align="right">10</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD></TR><TR><TD height="20">B</TD><TD align="right">5</TD></TR><TR><TD height="20">B</TD><TD align="right">10</TD></TR><TR><TD height="20">B</TD><TD align="right">5</TD></TR></TBODY></TABLE><P></P><P>Table 2:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="64">Start</TD><TD width="64">End</TD><TD width="64">Price</TD></TR><TR><TD height="20">A</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">100</TD></TR><TR><TD height="20">A</TD><TD align="right">4</TD><TD align="right">15</TD><TD align="right">110</TD></TR><TR><TD height="20">A</TD><TD align="right">16</TD><TD align="right">30</TD><TD align="right">120</TD></TR><TR><TD height="20">B</TD><TD align="right">1</TD><TD align="right">3</TD><TD align="right">160</TD></TR><TR><TD height="20">B</TD><TD align="right">4</TD><TD align="right">15</TD><TD align="right">200</TD></TR><TR><TD height="20">B</TD><TD align="right">16</TD><TD align="right">30</TD><TD align="right">210</TD></TR></TBODY></TABLE><P></P><P>and my output should be like this</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 220px;"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="92">Quantity Sold</TD><TD width="64">Price</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD><TD align="right">520</TD></TR><TR><TD height="20">A</TD><TD align="right">10</TD><TD align="right">1100</TD></TR><TR><TD height="20">A</TD><TD align="right">5</TD><TD align="right">600</TD></TR></TBODY></TABLE><P></P><P><SPAN style="color: black; font-family: 'Times New Roman', serif; font-size: 12pt;">This is how i am calculating first 5 quantity sold the total price is 520rs</SPAN></P><P><STRONG style="color: black; font-size: 10.0pt; font-family: 'Times New Roman','serif';">(3*100)+(2*110) = 520</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187257#M885548 2020-11-25T16:16:04Z Re: How to calucalte the value using the range https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187258#M885549 <HTML><HEAD></HEAD><BODY><P>Maybe use the solution that Sunny suggested in</P><P><A href="https://community.qlik.com/thread/233114">how to calculate values of by a range</A></P><P></P><P>(and please don't post multiple threads, if you are the same person that created the other thread</P><P>It just clutters the forum with redundant posts and makes it hard to follow a discussion)</P></BODY></HTML> Sun, 18 Sep 2016 20:30:14 GMT https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187258#M885549 swuehl 2016-09-18T20:30:14Z Re: How to calucalte the value using the range https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187259#M885550 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>Didn't get your output calculation.</P></BODY></HTML> Sun, 18 Sep 2016 20:31:53 GMT https://community.qlik.com/t5/QlikView/How-to-calucalte-the-value-using-the-range/m-p/1187259#M885550 ankitaag 2016-09-18T20:31:53Z