topic Re: Aggregation in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241844#M394289 <HTML><HEAD></HEAD><BODY><P>Sum(BroughtForward)</P><P></P><P>Dimension: Process &amp; Date</P></BODY></HTML> Mon, 20 Mar 2017 11:18:22 GMT manojkulkarni 2017-03-20T11:18:22Z Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241841#M394286 <HTML><HEAD></HEAD><BODY><P>HI Friend,</P><P></P><P>I am having below data in pivot table with date column expanded. I am expecting the results below in collapsed mode for same pivot table.</P><P>What should be my expression ? Appreciate your help.</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 697px;"><TBODY><TR><TD class="xl63" height="20" width="228"> </TD><TD class="xl63" style="border-left: none;" width="136">Date</TD><TD class="xl63" style="border-left: none;" width="111">Brought Forward</TD><TD class="xl63" style="border-left: none;" width="64">Opening</TD><TD class="xl63" style="border-left: none;" width="64">Closing</TD><TD class="xl63" style="border-left: none;" width="94">Carry Forward</TD></TR><TR><TD class="xl65" height="80" rowspan="4" style="border-top: none;" width="228">Process - 1</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">04-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">03-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">02-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">9</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">01-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">19</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">9</TD></TR><TR><TD class="xl65" height="80" rowspan="4" style="border-top: none;" width="228">Process - 2</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">04-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">03-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">7</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">02-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none; border-left: none;">01-02-2017</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5</TD></TR></TBODY></TABLE><P></P><P></P><P><STRONG>Expected Out Put </STRONG></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="603"><TBODY><TR><TD class="xl65" width="136">Brought Forward</TD><TD class="xl65" style="border-left: none;" width="111">Opening</TD><TD class="xl65" style="border-left: none;" width="64">Closing</TD><TD class="xl65" style="border-left: none;" width="64">Carry Forward</TD></TR><TR><TD height="20">Process - 1</TD><TD align="right" class="xl65" style="border-top: none;">6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD></TR><TR><TD height="20">Process - 2</TD><TD align="right" class="xl65" style="border-top: none;">7</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 20 Mar 2017 11:10:30 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241841#M394286 manojkulkarni 2017-03-20T11:10:30Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241842#M394287 <HTML><HEAD></HEAD><BODY><P>Please refer below mentioned link:</P><P><A href="https://community.qlik.com/qlik-blogpost/3015">Dimensions and Measures</A>‌</P><P></P><P>Hope it helps..</P><P></P><P></P><P>Regard's</P><P>Sarvesh Srivastava</P></BODY></HTML> Mon, 20 Mar 2017 11:12:38 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241842#M394287 sarvesh 2017-03-20T11:12:38Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241843#M394288 <HTML><HEAD></HEAD><BODY><P>What is your current expression?</P></BODY></HTML> Mon, 20 Mar 2017 11:14:05 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241843#M394288 sunny_talwar 2017-03-20T11:14:05Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241844#M394289 <HTML><HEAD></HEAD><BODY><P>Sum(BroughtForward)</P><P></P><P>Dimension: Process &amp; Date</P></BODY></HTML> Mon, 20 Mar 2017 11:18:22 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241844#M394289 manojkulkarni 2017-03-20T11:18:22Z Re: Aggregation in Pivot Table https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241845#M394290 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>FirstSortedValue(Aggr(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum(BroughtForward)</SPAN>, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Process</SPAN>, Date), -Aggr(Date, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Process</SPAN><SPAN style="font-size: 13.3333px;">, Date)</SPAN>)</STRONG></P></BODY></HTML> Mon, 20 Mar 2017 11:20:13 GMT https://community.qlik.com/t5/QlikView/Aggregation-in-Pivot-Table/m-p/1241845#M394290 sunny_talwar 2017-03-20T11:20:13Z