topic Calculate average based upon the Dimensions values. in QlikView https://community.qlik.com/t5/QlikView/Calculate-average-based-upon-the-Dimensions-values/m-p/1316859#M408696 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have a source dataset like as,</P><P></P><P>&nbsp; Source:</P><TABLE border="0" cellpadding="0" cellspacing="0" height="284" style="width: 227px; height: 224px;"><TBODY><TR><TD height="20" width="62">Category</TD><TD width="174">Date</TD><TD width="64"><P>Value_v1</P></TD></TR><TR><TD height="20">A</TD><TD>01/01/2017AM</TD><TD align="right"><TABLE border="0" cellpadding="0" cellspacing="0" width="100"><TBODY><TR><TD align="right" class="xl65" height="22" width="100">30518</TD></TR></TBODY></TABLE></TD></TR><TR><TD height="20">A</TD><TD>01/01/2017PM</TD><TD align="right">28484</TD></TR><TR><TD height="20">A</TD><TD>01/02/2017AM</TD><TD align="right">26806</TD></TR><TR><TD height="20">A</TD><TD>01/02/2017PM</TD><TD align="right">23227</TD></TR><TR><TD height="20">C</TD><TD>01/04/2017AM</TD><TD align="right">26083</TD></TR><TR><TD height="20">C</TD><TD>01/04/2017PM</TD><TD align="right">25642</TD></TR><TR><TD height="20">D</TD><TD>01/05/2017AM</TD><TD align="right">18996</TD></TR><TR><TD height="20">D</TD><TD>01/05/2017PM</TD><TD align="right">19939</TD></TR><TR><TD height="20">E</TD><TD>01/06/2017AM</TD><TD align="right">22555</TD></TR><TR><TD height="20">E</TD><TD>01/06/2017PM</TD><TD align="right">24746</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P><STRONG>Output:</STRONG></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#333333&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;1&quot;,&quot;backgroundColor&quot;:&quot;#FFFFFF&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#333333&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 513px;"><TBODY><TR><TD class="xl65" height="35" width="64">Category</TD><TD class="xl65" width="108">01/01/2017AM</TD><TD class="xl66" width="109">11/01/2017PM</TD><TD class="xl66" width="111">11/02/2017AM</TD><TD class="xl66" width="121">11/22/2017PM</TD></TR><TR><TD class="xl67" height="21" width="64">A</TD><TD class="xl68" width="108">-7%</TD><TD class="xl68" width="109">-6%</TD><TD class="xl68" width="111">-13%</TD><TD class="xl68" width="121">13%</TD></TR><TR><TD class="xl67" height="21" width="64">B</TD><TD class="xl69" width="108">-2%</TD><TD class="xl69" width="109">-1%</TD><TD class="xl69" width="111">4%</TD><TD class="xl69" width="121">-3%</TD></TR><TR><TD class="xl67" height="21" width="64">C</TD><TD class="xl69" width="108">5%</TD><TD class="xl69" width="109">-8%</TD><TD class="xl69" width="111">1%</TD><TD class="xl69" width="121">-11%</TD></TR><TR><TD class="xl67" height="21" width="64">D</TD><TD class="xl69" width="108">10%</TD><TD class="xl69" width="109">5%</TD><TD class="xl69" width="111">17%</TD><TD class="xl69" width="121">-23%</TD></TR><TR><TD class="xl67" height="21" width="64">E</TD><TD class="xl69" width="108">-3%</TD><TD class="xl69" width="109">0%</TD><TD class="xl69" width="111">-2%</TD><TD class="xl69" width="121">7%</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P></P><P>I need to calculate the average % based upon the Date value in the straight tablethe average %That means my calculation will be</P><P></P><P><STRONG>Example:</STRONG> Let me consider Category "A" value, for that i need the calculation like</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: underline;">Column1</STRONG><SPAN style="text-decoration: underline;">: </SPAN><STRONG style="text-decoration: underline;">(01/01/2017AM)</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) - <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) - / <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) </SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: underline;">Column2</STRONG><SPAN style="text-decoration: underline;">: </SPAN><STRONG style="text-decoration: underline;">(01/01/2017PM)</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) - <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) - / <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) </SPAN></SPAN></SPAN></P><P></P><P>Regards,</P><P>ShakilaD</P></BODY></HTML> Thu, 13 Apr 2017 20:32:48 GMT Anonymous 2017-04-13T20:32:48Z Calculate average based upon the Dimensions values. https://community.qlik.com/t5/QlikView/Calculate-average-based-upon-the-Dimensions-values/m-p/1316859#M408696 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have a source dataset like as,</P><P></P><P>&nbsp; Source:</P><TABLE border="0" cellpadding="0" cellspacing="0" height="284" style="width: 227px; height: 224px;"><TBODY><TR><TD height="20" width="62">Category</TD><TD width="174">Date</TD><TD width="64"><P>Value_v1</P></TD></TR><TR><TD height="20">A</TD><TD>01/01/2017AM</TD><TD align="right"><TABLE border="0" cellpadding="0" cellspacing="0" width="100"><TBODY><TR><TD align="right" class="xl65" height="22" width="100">30518</TD></TR></TBODY></TABLE></TD></TR><TR><TD height="20">A</TD><TD>01/01/2017PM</TD><TD align="right">28484</TD></TR><TR><TD height="20">A</TD><TD>01/02/2017AM</TD><TD align="right">26806</TD></TR><TR><TD height="20">A</TD><TD>01/02/2017PM</TD><TD align="right">23227</TD></TR><TR><TD height="20">C</TD><TD>01/04/2017AM</TD><TD align="right">26083</TD></TR><TR><TD height="20">C</TD><TD>01/04/2017PM</TD><TD align="right">25642</TD></TR><TR><TD height="20">D</TD><TD>01/05/2017AM</TD><TD align="right">18996</TD></TR><TR><TD height="20">D</TD><TD>01/05/2017PM</TD><TD align="right">19939</TD></TR><TR><TD height="20">E</TD><TD>01/06/2017AM</TD><TD align="right">22555</TD></TR><TR><TD height="20">E</TD><TD>01/06/2017PM</TD><TD align="right">24746</TD></TR><TR><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P><STRONG>Output:</STRONG></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#333333&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;1&quot;,&quot;backgroundColor&quot;:&quot;#FFFFFF&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#333333&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 513px;"><TBODY><TR><TD class="xl65" height="35" width="64">Category</TD><TD class="xl65" width="108">01/01/2017AM</TD><TD class="xl66" width="109">11/01/2017PM</TD><TD class="xl66" width="111">11/02/2017AM</TD><TD class="xl66" width="121">11/22/2017PM</TD></TR><TR><TD class="xl67" height="21" width="64">A</TD><TD class="xl68" width="108">-7%</TD><TD class="xl68" width="109">-6%</TD><TD class="xl68" width="111">-13%</TD><TD class="xl68" width="121">13%</TD></TR><TR><TD class="xl67" height="21" width="64">B</TD><TD class="xl69" width="108">-2%</TD><TD class="xl69" width="109">-1%</TD><TD class="xl69" width="111">4%</TD><TD class="xl69" width="121">-3%</TD></TR><TR><TD class="xl67" height="21" width="64">C</TD><TD class="xl69" width="108">5%</TD><TD class="xl69" width="109">-8%</TD><TD class="xl69" width="111">1%</TD><TD class="xl69" width="121">-11%</TD></TR><TR><TD class="xl67" height="21" width="64">D</TD><TD class="xl69" width="108">10%</TD><TD class="xl69" width="109">5%</TD><TD class="xl69" width="111">17%</TD><TD class="xl69" width="121">-23%</TD></TR><TR><TD class="xl67" height="21" width="64">E</TD><TD class="xl69" width="108">-3%</TD><TD class="xl69" width="109">0%</TD><TD class="xl69" width="111">-2%</TD><TD class="xl69" width="121">7%</TD></TR></TBODY></TABLE><P><SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P></P><P>I need to calculate the average % based upon the Date value in the straight tablethe average %That means my calculation will be</P><P></P><P><STRONG>Example:</STRONG> Let me consider Category "A" value, for that i need the calculation like</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: underline;">Column1</STRONG><SPAN style="text-decoration: underline;">: </SPAN><STRONG style="text-decoration: underline;">(01/01/2017AM)</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) - <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) - / <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) </SPAN></SPAN></SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG style="text-decoration: underline;">Column2</STRONG><SPAN style="text-decoration: underline;">: </SPAN><STRONG style="text-decoration: underline;">(01/01/2017PM)</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017AM) - <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) - / <SPAN style="font-size: 13.3333px;">(Value_v1 of </SPAN><SPAN style="font-size: 13.3333px;">01/01/2017PM) </SPAN></SPAN></SPAN></P><P></P><P>Regards,</P><P>ShakilaD</P></BODY></HTML> Thu, 13 Apr 2017 20:32:48 GMT https://community.qlik.com/t5/QlikView/Calculate-average-based-upon-the-Dimensions-values/m-p/1316859#M408696 Anonymous 2017-04-13T20:32:48Z