topic Calculating only First Rows on a Pivot Table? in QlikView https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810631#M286180 <HTML><HEAD></HEAD><BODY><P>Hi Qlikies,</P><P></P><P>I need to calculate only the first rows based on below example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Reference</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">Office</TD><TD style="padding: 2px;">2015/03/10</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD style="padding: 2px;">2015/03/10</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD style="padding: 2px;">2015/03/09</TD><TD style="padding: 2px;">90</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD>2015/03/08</TD><TD>90</TD></TR><TR><TD>Mark</TD><TD>2015/03/10</TD><TD>78</TD></TR><TR><TD>Mark</TD><TD>2015/03/10</TD><TD>55</TD></TR></TBODY></TABLE><P></P><P>Any Solution to this?</P><P></P><P></P><P>Regards.</P></BODY></HTML> Mon, 16 Mar 2015 13:54:55 GMT 2015-03-16T13:54:55Z Calculating only First Rows on a Pivot Table? https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810631#M286180 <HTML><HEAD></HEAD><BODY><P>Hi Qlikies,</P><P></P><P>I need to calculate only the first rows based on below example:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Reference</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">Office</TD><TD style="padding: 2px;">2015/03/10</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD style="padding: 2px;">2015/03/10</TD><TD style="padding: 2px;">90</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD style="padding: 2px;">2015/03/09</TD><TD style="padding: 2px;">90</TD></TR><TR><TD><SPAN style="font-size: 13.3333330154419px;">Office</SPAN></TD><TD>2015/03/08</TD><TD>90</TD></TR><TR><TD>Mark</TD><TD>2015/03/10</TD><TD>78</TD></TR><TR><TD>Mark</TD><TD>2015/03/10</TD><TD>55</TD></TR></TBODY></TABLE><P></P><P>Any Solution to this?</P><P></P><P></P><P>Regards.</P></BODY></HTML> Mon, 16 Mar 2015 13:54:55 GMT https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810631#M286180 2015-03-16T13:54:55Z Re: Calculating only First Rows on a Pivot Table? https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810632#M286181 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean? what ouput are you looking from the above example?</P><P></P><P>Best,</P><P>S</P></BODY></HTML> Mon, 16 Mar 2015 13:56:43 GMT https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810632#M286181 sunny_talwar 2015-03-16T13:56:43Z Re: Calculating only First Rows on a Pivot Table? https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810633#M286182 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use a conditional for any expression to do it.</P><P></P><P>Please If you like explain that you need to calculate...</P><P></P><P>Thx</P></BODY></HTML> Mon, 16 Mar 2015 13:57:46 GMT https://community.qlik.com/t5/QlikView/Calculating-only-First-Rows-on-a-Pivot-Table/m-p/810633#M286182 sorrakis01 2015-03-16T13:57:46Z