topic How to use the Functions in QlikView https://community.qlik.com/t5/QlikView/How-to-use-the-Functions/m-p/1187253#M885576 <HTML><HEAD></HEAD><BODY><P>Hi Team i am new to qlikview</P><P></P><P></P><P>I have two table like this</P><P></P><P>&nbsp;&nbsp; Table1: </P><TABLE border="0" cellpadding="0" cellspacing="0" width="284"><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></P><P></P><P>Table 2:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><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"><P>210</P></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" width="220"><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>&nbsp; </P><P>can You help me in sorting this</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to use the Functions https://community.qlik.com/t5/QlikView/How-to-use-the-Functions/m-p/1187253#M885576 <HTML><HEAD></HEAD><BODY><P>Hi Team i am new to qlikview</P><P></P><P></P><P>I have two table like this</P><P></P><P>&nbsp;&nbsp; Table1: </P><TABLE border="0" cellpadding="0" cellspacing="0" width="284"><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></P><P></P><P>Table 2:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><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"><P>210</P></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" width="220"><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>&nbsp; </P><P>can You help me in sorting this</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-Functions/m-p/1187253#M885576 2020-11-25T16:16:04Z Re: How to use the Functions https://community.qlik.com/t5/QlikView/How-to-use-the-Functions/m-p/1187254#M885577 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Maybe use the solution that Sunny suggested in</P><P style="font-size: 13.3333px;"><A href="https://community.qlik.com/thread/233114">how to calculate values of by a range</A></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">(and please don't post multiple threads, if you are the same person that created the other thread</P><P style="font-size: 13.3333px;">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:32 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-Functions/m-p/1187254#M885577 swuehl 2016-09-18T20:30:32Z