topic Re: QlikView “Copy Down” Previous NonZero Values in QlikView https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/933990#M322633 <HTML><HEAD></HEAD><BODY><P>You can employ the Peek()-function along with If() and sorting the table you read from on date ascending. I give this comment from a phone so I cant give you a full example....</P></BODY></HTML> Fri, 11 Sep 2015 14:21:07 GMT petter 2015-09-11T14:21:07Z QlikView “Copy Down” Previous NonZero Values https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/933989#M322632 <HTML><HEAD></HEAD><BODY><P style="margin: 0 0 1em; font-size: 15px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;">I have a QlikView application of Employees, months and salaries (along with other stuff, obviously). I have also a column that tells me the percentage pay movement this month.</P><P style="margin: 0 0 1em; font-size: 15px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;">I'd like to, in the Load Script, "copy down" this data so that I can find the most recent previous pay percentage increase and the month (please see the picture).</P><P style="margin: 0 0 1em; font-size: 15px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;">So I effectively have the yellow data, and want to generate the red data, for each employee ID. I'm not massively fussed on EXACTLY what the non-zero values are - i.e. if they're zero or NULL or anything.</P><P style="margin: 0 0 1em; font-size: 15px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><A href="http://i.imgur.com/Y4my7cm.png" rel="nofollow" style="font-size: 15px; color: #0c65a5;"><IMG alt="Y4my7cm.png" class="jive-image image-1" src="http://i.imgur.com/Y4my7cm.png" style="height: 216px; width: 620px;" /></A></P><P style="margin: 0 0 1em; font-size: 15px; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;">Should probably note, this isn't my Excel/CSV file, this is the actual QlikView table - due to the way our data comes out of the source system, we have to calculate basic pay movements in the load script (along with other stuff) using 3 or 4 temporary tables, then load them all together.</P></BODY></HTML> Fri, 11 Sep 2015 13:19:00 GMT https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/933989#M322632 2015-09-11T13:19:00Z Re: QlikView “Copy Down” Previous NonZero Values https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/933990#M322633 <HTML><HEAD></HEAD><BODY><P>You can employ the Peek()-function along with If() and sorting the table you read from on date ascending. I give this comment from a phone so I cant give you a full example....</P></BODY></HTML> Fri, 11 Sep 2015 14:21:07 GMT https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/933990#M322633 petter 2015-09-11T14:21:07Z Re: QlikView “Copy Down” Previous NonZero Values https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/1808057#M1212315 <P>Any solution yet?</P> Fri, 14 May 2021 16:37:00 GMT https://community.qlik.com/t5/QlikView/QlikView-Copy-Down-Previous-NonZero-Values/m-p/1808057#M1212315 callmedaddy 2021-05-14T16:37:00Z