https://community.qlik.com/t5/QlikView/How-to-Reference-Previous-value-in-a-chart/m-p/1656618#M456091 <P>Hey Tim, I cannot see any attachment, just wanted to flag that for you, likely why you have not received any responses yet!</P> <P>Cheers,<BR />Brett</P> Wed, 11 Dec 2019 15:35:47 GMT Brett_Bleess 2019-12-11T15:35:47Z https://community.qlik.com/t5/QlikView/How-to-Reference-Previous-value-in-a-chart/m-p/1653632#M456090 <P>Hi All,</P><P>I have a chart in the following format (see attached).&nbsp; Currently, the variable "SHUT_IN_COMMENTS" only displays for the first day.&nbsp; I want to comment to display for all days in which the variable "SHUT_IN" = 1.&nbsp; Here is the logic I need:</P><P>If SHUT_IN = previous(SHUT_IN) AND WellName = previous(WellName) then print previous SHUT_IN_COMMENTS else print current SHUT_IN_COMMENTS.</P><P>This won't work in the script due to the sorting.&nbsp; I did the sorting in my chart/table, but am having a problem getting the above function to work property.</P> Sat, 16 Nov 2024 01:47:39 GMT https://community.qlik.com/t5/QlikView/How-to-Reference-Previous-value-in-a-chart/m-p/1653632#M456090 timbatman 2024-11-16T01:47:39Z https://community.qlik.com/t5/QlikView/How-to-Reference-Previous-value-in-a-chart/m-p/1656618#M456091 <P>Hey Tim, I cannot see any attachment, just wanted to flag that for you, likely why you have not received any responses yet!</P> <P>Cheers,<BR />Brett</P> Wed, 11 Dec 2019 15:35:47 GMT https://community.qlik.com/t5/QlikView/How-to-Reference-Previous-value-in-a-chart/m-p/1656618#M456091 Brett_Bleess 2019-12-11T15:35:47Z