topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/431076#M160711 <HTML><HEAD></HEAD><BODY><DIV>Hi, </DIV><DIV> </DIV><DIV>I am using a pivot table as below;</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TransNo</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan 2012</TD><TD>ABC1</TD><TD>1</TD><TD>250</TD></TR><TR><TD>Feb 2012</TD><TD>ABC2</TD><TD>1</TD><TD>50</TD></TR><TR><TD>Feb2012</TD><TD>ABC3</TD><TD>1</TD><TD>100</TD></TR><TR><TD>Mar2012</TD><TD>ABC4</TD><TD>1</TD><TD>25</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>the value is being calculated by; </DIV><DIV><EM>if<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Returns]</SPAN><SPAN style="font-size: 8pt;">&gt;0,(max(Aggr(sum(Value),TransNo)))) </SPAN></EM></DIV><DIV> </DIV><DIV> </DIV><DIV><SPAN style="font-size: 10pt;">However when the columns are collapsed it shows the total value rather than the value for returns. </SPAN></DIV><DIV> </DIV><DIV><SPAN style="font-size: 10pt;">How it is:</SPAN></DIV><DIV><SPAN style="font-size: 10pt;"><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan2012</TD><TD>1</TD><TD>1,000</TD></TR><TR><TD>Feb2012</TD><TD>2</TD><TD>2,000</TD></TR><TR><TD>Mar2012</TD><TD>1</TD><TD>1,500</TD></TR></TBODY></TABLE></SPAN></DIV><P></P><P>How it should be:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan2012</TD><TD>1</TD><TD>250</TD></TR><TR><TD>Feb2012</TD><TD>2</TD><TD>150</TD></TR><TR><TD>Mar2012</TD><TD>1</TD><TD>25</TD></TR></TBODY></TABLE><P></P><P></P><P>If anyone could help me resolve this issue it would be much appreciated. </P><P>Thanks in advance!</P></BODY></HTML> Mon, 08 Apr 2013 09:25:27 GMT 2013-04-08T09:25:27Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/431076#M160711 <HTML><HEAD></HEAD><BODY><DIV>Hi, </DIV><DIV> </DIV><DIV>I am using a pivot table as below;</DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>TransNo</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan 2012</TD><TD>ABC1</TD><TD>1</TD><TD>250</TD></TR><TR><TD>Feb 2012</TD><TD>ABC2</TD><TD>1</TD><TD>50</TD></TR><TR><TD>Feb2012</TD><TD>ABC3</TD><TD>1</TD><TD>100</TD></TR><TR><TD>Mar2012</TD><TD>ABC4</TD><TD>1</TD><TD>25</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV>the value is being calculated by; </DIV><DIV><EM>if<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Returns]</SPAN><SPAN style="font-size: 8pt;">&gt;0,(max(Aggr(sum(Value),TransNo)))) </SPAN></EM></DIV><DIV> </DIV><DIV> </DIV><DIV><SPAN style="font-size: 10pt;">However when the columns are collapsed it shows the total value rather than the value for returns. </SPAN></DIV><DIV> </DIV><DIV><SPAN style="font-size: 10pt;">How it is:</SPAN></DIV><DIV><SPAN style="font-size: 10pt;"><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan2012</TD><TD>1</TD><TD>1,000</TD></TR><TR><TD>Feb2012</TD><TD>2</TD><TD>2,000</TD></TR><TR><TD>Mar2012</TD><TD>1</TD><TD>1,500</TD></TR></TBODY></TABLE></SPAN></DIV><P></P><P>How it should be:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Returns</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>Jan2012</TD><TD>1</TD><TD>250</TD></TR><TR><TD>Feb2012</TD><TD>2</TD><TD>150</TD></TR><TR><TD>Mar2012</TD><TD>1</TD><TD>25</TD></TR></TBODY></TABLE><P></P><P></P><P>If anyone could help me resolve this issue it would be much appreciated. </P><P>Thanks in advance!</P></BODY></HTML> Mon, 08 Apr 2013 09:25:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/431076#M160711 2013-04-08T09:25:27Z