topic Re: Calculating values ​​previous row in QlikView https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379532#M141535 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Try this:</P><P></P><P>percentage adjustment * (1 + peek ('Title of the column'))</P><P></P><P>'Title of the column shall be the title of the red one in your example.</P><P>Rgds</P></BODY></HTML> Tue, 21 Aug 2012 12:01:13 GMT 2012-08-21T12:01:13Z Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379530#M141533 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">hello</SPAN>, I need an <SPAN class="hps">expression</SPAN> <SPAN class="hps">that calculates</SPAN> <SPAN class="hps">the value of</SPAN> <SPAN class="hps">always</SPAN> <SPAN class="hps">using</SPAN> <SPAN class="hps">the previous line</SPAN>, <SPAN class="hps">is an example</SPAN> <SPAN class="hps">in excel</SPAN>, <SPAN class="hps">need to do</SPAN> <SPAN class="hps">the same in</SPAN> <SPAN class="hps">QlikView</SPAN>.</P><P> <SPAN class="hps">thank you.</SPAN></P></BODY></HTML> Tue, 21 Aug 2012 11:50:42 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379530#M141533 rogeriobarbosa 2012-08-21T11:50:42Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379531#M141534 <HTML><HEAD></HEAD><BODY><P>look in help for Peek:</P><P>Peek('Sales')</P></BODY></HTML> Tue, 21 Aug 2012 11:59:03 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379531#M141534 2012-08-21T11:59:03Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379532#M141535 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Try this:</P><P></P><P>percentage adjustment * (1 + peek ('Title of the column'))</P><P></P><P>'Title of the column shall be the title of the red one in your example.</P><P>Rgds</P></BODY></HTML> Tue, 21 Aug 2012 12:01:13 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379532#M141535 2012-08-21T12:01:13Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379533#M141536 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try this</P><P>RowNo()*(1+FieldNameB))</P></BODY></HTML> Tue, 21 Aug 2012 12:08:16 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379533#M141536 sreenivas 2012-08-21T12:08:16Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379534#M141537 <HTML><HEAD></HEAD><BODY><P>if you are doing it in the front end, ie a pivot table report use the Above() function</P></BODY></HTML> Tue, 21 Aug 2012 12:12:22 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379534#M141537 2012-08-21T12:12:22Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379535#M141538 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">hello</SPAN>, I need to <SPAN class="hps">do in the</SPAN> <SPAN class="hps">expression</SPAN> <SPAN class="hps">could</SPAN> <SPAN class="hps">not</SPAN> <SPAN class="hps">do using the</SPAN> <SPAN class="hps">above</SPAN> <SPAN class="hps">help me please</SPAN></P></BODY></HTML> Tue, 21 Aug 2012 12:21:41 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379535#M141538 rogeriobarbosa 2012-08-21T12:21:41Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379536#M141539 <HTML><HEAD></HEAD><BODY><P>Try this one, it works for me:</P><P></P><P>LOAD [months years], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [percentage adjustment], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; sale,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if([percentage adjustment]='',1+peek(Column)) as KEY,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Column</P><P>FROM</P><P>[Example (1).xls]</P></BODY></HTML> Tue, 21 Aug 2012 12:28:01 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379536#M141539 2012-08-21T12:28:01Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379537#M141540 <HTML><HEAD></HEAD><BODY><P>If you want this as an expression in a straight table you'll have to use above()</P><P>If you use a pivot table you'll have to use above() or before() depending on how you arrange the fields.</P><P></P><P>Assuming you want to use a straight table </P><P>Add [months years] as the dimension then add the following expresssions.</P><P>(Ensure [months years]&nbsp; is sorted correctly)</P><P></P><P><STRONG>sale</STRONG></P><P>sum(sale)</P><P></P><P><STRONG>adj</STRONG></P><P>sum([percentage adjustment])</P><P></P><P><STRONG>calc</STRONG> </P><P><EM>if(RowNo()=1,1</EM></P><P><EM>&nbsp; ,Above(calc) * (adj + 1)</EM></P><P><EM>&nbsp; )</EM></P><P></P><P><STRONG>sale2</STRONG> </P><P><EM>calc * sale</EM></P><P></P><P></P><P></P><P></P><P>Mark</P></BODY></HTML> Tue, 21 Aug 2012 14:47:27 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379537#M141540 RedSky001 2012-08-21T14:47:27Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379538#M141541 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Thank you,</SPAN> <SPAN class="hps">that was exactly</SPAN> <SPAN class="hps">what I need.</SPAN></P></BODY></HTML> Tue, 21 Aug 2012 15:04:54 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379538#M141541 rogeriobarbosa 2012-08-21T15:04:54Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379539#M141542 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 11.818181991577148px; background-color: #ffffff;">Please can you mark the right </SPAN><EM class="jive-hilite" style="background-color: #ffffcd; font-size: 11.818181991577148px; font-weight: bold; color: #636363; font-family: Arial;">answer</EM><SPAN style="color: #636363; font-family: Arial; font-size: 11.818181991577148px; background-color: #ffffff;"> as "</SPAN><EM class="jive-hilite" style="background-color: #ffffcd; font-size: 11.818181991577148px; font-weight: bold; color: #636363; font-family: Arial;">Correct</EM><SPAN style="color: #636363; font-family: Arial; font-size: 11.818181991577148px; background-color: #ffffff;"> </SPAN><EM class="jive-hilite" style="background-color: #ffffcd; font-size: 11.818181991577148px; font-weight: bold; color: #636363; font-family: Arial;">Answer</EM><SPAN style="color: #636363; font-family: Arial; font-size: 11.818181991577148px; background-color: #ffffff;">"?&nbsp; I need the points for my ego <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 11.818181991577148px; background-color: #ffffff;">Mark </SPAN></P></BODY></HTML> Tue, 21 Aug 2012 15:18:38 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379539#M141542 RedSky001 2012-08-21T15:18:38Z Re: Calculating values ​​previous row https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379540#M141543 <HTML><HEAD></HEAD><BODY><P>Ok, trank.</P><P></P><P> </P><P></P><P> </P><P></P><P>De: msheraton <A href="mailto:qcwebmaster@qlik.com"></A> </P><P>Enviada em: terça-feira, 21 de agosto de 2012 12:19</P><P>Para: ROGERIOBARBOSA</P><P>Assunto: <A href="Development (QlikView Desktop)"></A> - Re: Calculating values ​​previous row</P><P></P><P> </P><P></P><P></P><P></P><P></P><P> &lt;http://community.qlik.com/index.jspa&gt; QlikCommunity</P><P></P><P></P><P></P><P>Re: Calculating values ​​previous row </P><P></P><P></P><P>created by msheraton &lt;http://community.qlik.com/people/msheraton&gt; in Development (QlikView Desktop) - View the full &lt;http://community.qlik.com/message/250296#250296&gt; discussion</P></BODY></HTML> Tue, 21 Aug 2012 16:44:13 GMT https://community.qlik.com/t5/QlikView/Calculating-values-previous-row/m-p/379540#M141543 rogeriobarbosa 2012-08-21T16:44:13Z