https://community.qlik.com/t5/App-Development/Show-changes-based-on-previous-value-of-fields/m-p/1669970#M50612 <P>Can you please provide the desired output for the shared sample input&nbsp;</P> Tue, 28 Jan 2020 10:45:03 GMT anushree1 2020-01-28T10:45:03Z https://community.qlik.com/t5/App-Development/Show-changes-based-on-previous-value-of-fields/m-p/1669631#M50564 <P>Hi All,</P><P>I am trying to produce a "Change Event" within a visualisation.</P><P>I have some data which is a list of ~50 parameters, each parameter has an Open (1) or Closed (0) value which is logged every 5ish seconds.</P><P>I want to look at 6 of the ~50 parameters, and if any of the specified parameters has changed it's value, then make a new measure show a value =/ 0</P><P>I've tried this using set analysis and above() function but haven't had any joy trying to combine the two.</P><P>My data looks something like this.</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Timestamp</TD><TD>Open/Closed</TD><TD>Parameter</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>0.0</TD><TD>27</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>0.0</TD><TD>28</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>0.0</TD><TD>29</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>0.0</TD><TD>34</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>0.0</TD><TD>35</TD></TR><TR><TD>2020-01-22 08:50:41</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:50:52</TD><TD>0.0</TD><TD>27</TD></TR><TR><TD>2020-01-22 08:50:52</TD><TD>0.0</TD><TD>29</TD></TR><TR><TD>2020-01-22 08:50:52</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:50:53</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:50:57</TD><TD>0.0</TD><TD>27</TD></TR><TR><TD>2020-01-22 08:50:57</TD><TD>0.0</TD><TD>29</TD></TR><TR><TD>2020-01-22 08:50:57</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:50:59</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:51:03</TD><TD>0.0</TD><TD>27</TD></TR><TR><TD>2020-01-22 08:51:03</TD><TD>0.0</TD><TD>29</TD></TR><TR><TD>2020-01-22 08:51:03</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:51:05</TD><TD>1.0</TD><TD>26</TD></TR><TR><TD>2020-01-22 08:51:09</TD><TD>0.0</TD><TD>27</TD></TR><TR><TD>2020-01-22 08:51:09</TD><TD>0.0</TD><TD>29</TD></TR><TR><TD>2020-01-22 08:51:09</TD><TD>1.0</TD><TD>26</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any advice appreciated.</P><P><BR />Thanks</P> Mon, 20 Dec 2021 21:38:40 GMT https://community.qlik.com/t5/App-Development/Show-changes-based-on-previous-value-of-fields/m-p/1669631#M50564 RobinP 2021-12-20T21:38:40Z https://community.qlik.com/t5/App-Development/Show-changes-based-on-previous-value-of-fields/m-p/1669970#M50612 <P>Can you please provide the desired output for the shared sample input&nbsp;</P> Tue, 28 Jan 2020 10:45:03 GMT https://community.qlik.com/t5/App-Development/Show-changes-based-on-previous-value-of-fields/m-p/1669970#M50612 anushree1 2020-01-28T10:45:03Z