topic Re: Aggregation for pivot in QlikView https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505287#M188924 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Mon, 22 Jul 2013 05:40:41 GMT 2013-07-22T05:40:41Z Aggregation for pivot https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505285#M188922 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Aggregation function not working properly.</P><P>At present i am getting values as</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#ffffff"><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Plant</STRONG></SPAN><STRONG> </STRONG></TH><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=DATE(Date)</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><BR /></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">A</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">135.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">162.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">189.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">216.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">B</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">C</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD></TR></TBODY></TABLE><P> i need&nbsp; is</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#ffffff"><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Type Of Plant</STRONG></SPAN><STRONG> </STRONG></TH><TH bgcolor="#f5f5f5" nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>=DATE(Date)</STRONG></SPAN><STRONG> </STRONG></TH><TD bgcolor="#ffffff"><BR /></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">A</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">135.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">162.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">189.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">216.00</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">B</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">135.00</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">162.00</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <P><SPAN style="color: #363636;">189.00</SPAN><SPAN style="font-size: 12px; background-color: #ffffff;"> </SPAN></P></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">216.00</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff" rowspan="4"><SPAN style="color: #363636;">C</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">135.00</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">162.00</SPAN></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">6/1/2012</SPAN> </TD><TD bgcolor="#ffffff"> <P><SPAN style="color: #363636;">189.00</SPAN><SPAN style="font-size: 12px; background-color: #ffffff;"> </SPAN></P></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">7/1/2012</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636; font-size: 12px; background-color: #ffffff;">216.00</SPAN></TD></TR></TBODY></TABLE><P>ie In&nbsp; the last field i should get the total for all the Type of plant wrt to a particular date</P><P></P><P>Please find the attached qvw.</P><P></P><P>Thanks and Regards,</P><P>Priya</P></BODY></HTML> Mon, 22 Jul 2013 04:56:49 GMT https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505285#M188922 2013-07-22T04:56:49Z Re: Aggregation for pivot https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505286#M188923 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P>aggr(<STRONG>NODISTINCT</STRONG>(sum(HSD)-sum(Rated)),Date)</P></BODY></HTML> Mon, 22 Jul 2013 05:31:01 GMT https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505286#M188923 tresB 2013-07-22T05:31:01Z Re: Aggregation for pivot https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505287#M188924 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Mon, 22 Jul 2013 05:40:41 GMT https://community.qlik.com/t5/QlikView/Aggregation-for-pivot/m-p/505287#M188924 2013-07-22T05:40:41Z