topic Re: Pivot table in QlikView https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164251#M379204 <HTML><HEAD></HEAD><BODY><P>Please try this in your expression</P><P>Sum(TOTAL&lt;Start,Transit&gt; Weight)</P></BODY></HTML> Mon, 04 Jul 2016 06:40:23 GMT 2016-07-04T06:40:23Z Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164250#M379203 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HI everybody!</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I began working with QV not long ago and have a question, </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How to transform the followinf table:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="456"><TBODY><TR><TD class="xl63" height="20" width="79">Start</TD><TD class="xl63" width="141">Transit</TD><TD class="xl63" width="126">End</TD><TD class="xl63" width="110">sum(Weight)</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>C</TD><TD align="right">10</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>D</TD><TD align="right">20</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>E</TD><TD align="right">5</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>F</TD><TD align="right">30</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>G</TD><TD align="right">5</TD></TR><TR><TD height="20">H</TD><TD>I</TD><TD>J</TD><TD align="right">10</TD></TR><TR><TD height="20">H</TD><TD>I</TD><TD>K</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P>into;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="456"><TBODY><TR><TD class="xl65" height="20" width="79">Start</TD><TD class="xl65" width="141">Transit</TD><TD class="xl65" width="126">End</TD><TD class="xl65" width="110">sum(Weight)</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>C</TD><TD align="right">70</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>D</TD><TD align="right">70</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>E</TD><TD align="right">70</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>F</TD><TD align="right">70</TD></TR><TR><TD height="20">A</TD><TD>B</TD><TD>G</TD><TD align="right">70</TD></TR><TR><TD height="20">H</TD><TD>I</TD><TD>J</TD><TD align="right">20</TD></TR><TR><TD height="20">H</TD><TD>I</TD><TD>K</TD><TD align="right">20</TD></TR></TBODY></TABLE><P></P><P>I need to group the column with the result by "Transit" field but keeping the "End" column.</P><P>Is it possible to do in the diagram expressions?</P></BODY></HTML> Mon, 04 Jul 2016 06:30:04 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164250#M379203 2016-07-04T06:30:04Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164251#M379204 <HTML><HEAD></HEAD><BODY><P>Please try this in your expression</P><P>Sum(TOTAL&lt;Start,Transit&gt; Weight)</P></BODY></HTML> Mon, 04 Jul 2016 06:40:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164251#M379204 2016-07-04T06:40:23Z Re: Pivot table https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164252#M379205 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Nhu Ngo, thanks a lot, it works!</SPAN></P></BODY></HTML> Mon, 04 Jul 2016 07:32:53 GMT https://community.qlik.com/t5/QlikView/Pivot-table/m-p/1164252#M379205 2016-07-04T07:32:53Z