https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921959#M1231975 <P>Hi all,</P> <P>I have a case as below, please give me some advises to correct the formula</P> <P>Date sample:&nbsp;</P> <TABLE width="427"> <TBODY> <TR> <TD width="113">Customer code</TD> <TD width="84">Date</TD> <TD width="116">Amount of Billing</TD> <TD width="114">&nbsp;Closing Balance&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/01/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000</TD> </TR> <TR> <TD>092</TD> <TD>01/02/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/03/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/04/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/01/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000</TD> </TR> <TR> <TD>193</TD> <TD>01/02/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/03/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/04/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Desired reults</P> <TABLE width="405px"> <TBODY> <TR> <TD width="96.7188px">Customer code</TD> <TD width="85.9844px">Date</TD> <TD width="111.688px">&nbsp;Amount of Billing&nbsp;</TD> <TD width="109.609px">&nbsp;Closing Balance&nbsp;</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/01/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/02/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 94,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/03/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/04/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/01/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/02/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 148,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/03/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 145,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/04/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 141,000</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I group and order data by Customer Code and Date, the formula is:</P> <P>If(IsNull("Closing Balance") ,Peek("Closing Balance")&nbsp; - "Amount of Billing", "Closing Balance") as "Closing Balance"</P> <P>The problem is that the results is not separate by Customer code, it only use the "Closing Balance" of the first Customer and combine "Amount of Billing" of all customer with the same Date to calculate</P> Mon, 26 Jan 2026 16:26:21 GMT nguyettran_uct 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921959#M1231975 <P>Hi all,</P> <P>I have a case as below, please give me some advises to correct the formula</P> <P>Date sample:&nbsp;</P> <TABLE width="427"> <TBODY> <TR> <TD width="113">Customer code</TD> <TD width="84">Date</TD> <TD width="116">Amount of Billing</TD> <TD width="114">&nbsp;Closing Balance&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/01/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000</TD> </TR> <TR> <TD>092</TD> <TD>01/02/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/03/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>092</TD> <TD>01/04/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/01/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000</TD> </TR> <TR> <TD>193</TD> <TD>01/02/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/03/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>193</TD> <TD>01/04/2022</TD> <TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Desired reults</P> <TABLE width="405px"> <TBODY> <TR> <TD width="96.7188px">Customer code</TD> <TD width="85.9844px">Date</TD> <TD width="111.688px">&nbsp;Amount of Billing&nbsp;</TD> <TD width="109.609px">&nbsp;Closing Balance&nbsp;</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/01/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/02/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 94,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/03/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87,000</TD> </TR> <TR> <TD width="96.7188px">092</TD> <TD width="85.9844px">01/04/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/01/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/02/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 148,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/03/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 145,000</TD> </TR> <TR> <TD width="96.7188px">193</TD> <TD width="85.9844px">01/04/2022</TD> <TD width="111.688px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,000</TD> <TD width="109.609px">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 141,000</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I group and order data by Customer Code and Date, the formula is:</P> <P>If(IsNull("Closing Balance") ,Peek("Closing Balance")&nbsp; - "Amount of Billing", "Closing Balance") as "Closing Balance"</P> <P>The problem is that the results is not separate by Customer code, it only use the "Closing Balance" of the first Customer and combine "Amount of Billing" of all customer with the same Date to calculate</P> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921959#M1231975 nguyettran_uct 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921967#M1231979 <P>Hi,</P> <P>Try the following code:</P> <P>DATA_TMP:<BR /><STRONG>LOAD</STRONG> * Inline[<BR />Customer code,&nbsp; Date, Amount of Billing,&nbsp;&nbsp; Closing Balance <BR />092, 01/01/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100000<BR />092, 01/02/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000, <BR />092, 01/03/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7000, <BR />092, 01/04/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8000, <BR />193, 01/01/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1000, &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150000<BR />193, 01/02/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000, <BR />193, 01/03/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000, <BR />193, 01/04/2022,&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000, <BR />];<BR /><BR />DATA:<BR />NoConcatenate<BR /><STRONG>LOAD</STRONG><BR />&nbsp;&nbsp;&nbsp;&nbsp; [Customer code],&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp; Date, <BR />&nbsp;&nbsp;&nbsp;&nbsp; [Amount of Billing],<BR />&nbsp;&nbsp;&nbsp;&nbsp; IF([Customer code] = Previous([Customer code]), Peek("Closing Balance")-[Amount of Billing], [Closing Balance])&nbsp; AS [Closing Balance]<BR />Resident DATA_TMP<BR />Order By [Customer code], Date;<BR /><STRONG>DROP</STRONG> Table DATA_TMP;</P> <P>&nbsp;</P> <P>My result:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vchuprina_0-1650874747345.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77778i80F207796557A3F1/image-size/medium?v=v2&amp;px=400" role="button" title="vchuprina_0-1650874747345.png" alt="vchuprina_0-1650874747345.png" /></span></P> <P>&nbsp;</P> <P>Regards,</P> <P>Vitalii</P> Mon, 25 Apr 2022 08:16:39 GMT https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921967#M1231979 vchuprina 2022-04-25T08:16:39Z https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921973#M1231982 <P>Hi&nbsp; V<SPAN class="UserName lia-user-name lia-user-rank-Creator-III"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="">chuprina,&nbsp;</SPAN></SPAN></SPAN></P> <P><SPAN class="UserName lia-user-name lia-user-rank-Creator-III"><SPAN class="lia-link-navigation lia-page-link lia-link-disabled lia-user-name-link"><SPAN class="">It's&nbsp; work, thank you for your support&nbsp;<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></SPAN></SPAN></SPAN></P> <DIV id="messageEditor_cba8e779205fe7_0" class="MessageEditor"><A id="previewButton_cba8e779205fe7_6bcc7" class="lia-link-navigation lia-message-editor-preview-button" href="https://community.qlik.com/t5/QlikView-Integrations/Peek-Funtion/m-p/1921959#" target="_blank">PREVIEW</A> <DIV class="lia-js-block-events"> <DIV class="lia-form-row lia-form-body-entry"> <DIV class="lia-quilt-row lia-quilt-row-standard"> <DIV class="lia-quilt-column lia-quilt-column-24 lia-quilt-column-single"> <DIV class="lia-quilt-column-alley lia-quilt-column-alley-single"> <DIV class="lia-form-input-wrapper"> <DIV id="rich_cba8e779205fe7_6bcc7" class="message-body-editor lia-inline-message-body-editor"> <DIV class="lia-inline-ajax-feedback">&nbsp;</DIV> <DIV id="mceu_91" class="mce-tinymce mce-container mce-panel lia-editor-gte-2" tabindex="-1" role="application"> <DIV id="mceu_91-body" class="mce-container-body mce-stack-layout"> <DIV id="mceu_92" class="mce-top-part mce-container mce-stack-layout-item mce-first"> <DIV id="mceu_92-body" class="mce-container-body"> <DIV id="mceu_93" class="mce-toolbar-grp mce-container mce-panel mce-first mce-last" tabindex="-1" role="group"> <DIV id="mceu_93-body" class="mce-container-body mce-stack-layout"> <DIV id="mceu_94" class="mce-container mce-toolbar mce-stack-layout-item mce-first" role="toolbar"> <DIV id="mceu_94-body" class="mce-container-body mce-flow-layout"> <DIV id="mceu_95" class="mce-container mce-flow-layout-item mce-first mce-last mce-btn-group" role="group"> <DIV id="mceu_95-body"> <DIV id="mceu_52" class="mce-widget mce-btn mce-btn-small mce-first" tabindex="0" role="button" aria-label="Undo" aria-disabled="false">&nbsp;</DIV> <DIV id="mceu_53" class="mce-widget mce-btn mce-btn-small lia-mce-toolbar-bold" tabindex="0" role="button" aria-pressed="false" aria-label="Bold">&nbsp;</DIV> <DIV id="mceu_54" class="mce-widget mce-btn mce-btn-small lia-mce-toolbar-italic" tabindex="0" role="button" aria-pressed="false" aria-label="Italic">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> Mon, 25 Apr 2022 08:37:12 GMT https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921973#M1231982 nguyettran_uct 2022-04-25T08:37:12Z https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921982#M1231985 <P>Welcome!</P> Mon, 25 Apr 2022 08:52:41 GMT https://community.qlik.com/t5/QlikView/Peek-Funtion/m-p/1921982#M1231985 vchuprina 2022-04-25T08:52:41Z