https://community.qlik.com/t5/QlikView/Pivot-table-get-previous-value/m-p/1742263#M453037 <P>There is Before() function that could help you with your issue, take a look here:&nbsp;<A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/before.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/before.htm</A></P> Wed, 09 Sep 2020 07:08:32 GMT dapostolopoylos 2020-09-09T07:08:32Z https://community.qlik.com/t5/QlikView/Pivot-table-get-previous-value/m-p/1741772#M452992 <P>Good day all,</P><P>I have a pivot table with 4 dimensions one being random dates, this date field forms the column headings. Some of the rows may have a value for a certain date and for the same row there may be a 0 value for one or more of the date columns. I need to populate the 0 rows with the previous non 0 value..</P><P>&nbsp;</P><P>Thank you&nbsp;</P><P>Kamiel</P> Mon, 07 Sep 2020 20:20:38 GMT https://community.qlik.com/t5/QlikView/Pivot-table-get-previous-value/m-p/1741772#M452992 kamielrajaram 2020-09-07T20:20:38Z https://community.qlik.com/t5/QlikView/Pivot-table-get-previous-value/m-p/1742263#M453037 <P>There is Before() function that could help you with your issue, take a look here:&nbsp;<A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/before.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/before.htm</A></P> Wed, 09 Sep 2020 07:08:32 GMT https://community.qlik.com/t5/QlikView/Pivot-table-get-previous-value/m-p/1742263#M453037 dapostolopoylos 2020-09-09T07:08:32Z