topic Re: First record for a specific field. in QlikView https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679383#M246368 <HTML><HEAD></HEAD><BODY><P>hi</P><P>use 'top' keyword.</P><P>sum( Sales ) / top( sum( Sales ))</P><P></P><P>HTH</P><P>Ravi N.</P></BODY></HTML> Mon, 30 Jun 2014 11:29:29 GMT Anonymous 2014-06-30T11:29:29Z First record for a specific field. https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679382#M246367 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to create a formula where my requirement is sum(Sales) / first record from 'Sales' field.</P><P>Can any one suggest me how to find the first record value from chart expression.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 30 Jun 2014 11:27:39 GMT https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679382#M246367 soha1902 2014-06-30T11:27:39Z Re: First record for a specific field. https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679383#M246368 <HTML><HEAD></HEAD><BODY><P>hi</P><P>use 'top' keyword.</P><P>sum( Sales ) / top( sum( Sales ))</P><P></P><P>HTH</P><P>Ravi N.</P></BODY></HTML> Mon, 30 Jun 2014 11:29:29 GMT https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679383#M246368 Anonymous 2014-06-30T11:29:29Z Re: First record for a specific field. https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679384#M246369 <HTML><HEAD></HEAD><BODY><P>Use =fieldvalue('Sales',1)</P></BODY></HTML> Mon, 30 Jun 2014 11:29:54 GMT https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679384#M246369 Gysbert_Wassenaar 2014-06-30T11:29:54Z Re: First record for a specific field. https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679385#M246370 <HTML><HEAD></HEAD><BODY><P>Thanks</P><DIV class="j-act-sub-preview"><DIV class="j-author-act font-color-meta-light"><A _jive_internal="true" data-avatarid="6257" data-externalid="" data-online="false" data-presence="null" data-userid="96544" data-username="gwassenaar" href="https://community.qlik.com/people/gwassenaar">Gysbert Wassenaar</A></DIV></DIV></BODY></HTML> Mon, 30 Jun 2014 11:33:23 GMT https://community.qlik.com/t5/QlikView/First-record-for-a-specific-field/m-p/679385#M246370 soha1902 2014-06-30T11:33:23Z