https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1590581#M738391 <P>Hi</P><P>This is my data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Contract</TD><TD>Status</TD><TD>AMOUNT</TD><TD>STATUS_DATE_From</TD><TD>STATUS_DATE_Next</TD><TD>Change Number</TD></TR><TR><TD>1001700</TD><TD>10</TD><TD>-287110.56</TD><TD>09/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>1</TD></TR><TR><TD>1001700</TD><TD>5</TD><TD>72320.75</TD><TD>20/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>2</TD></TR><TR><TD>1001700</TD><TD>50</TD><TD>72320.75</TD><TD>20/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>3</TD></TR><TR><TD>1001700</TD><TD>60</TD><TD>72320.75</TD><TD>30/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>4</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>72320.75</TD><TD>30/08/2017 00:00</TD><TD>24/09/2017 00:00</TD><TD>5</TD></TR><TR><TD>1001700</TD><TD>96</TD><TD>72320.75</TD><TD>24/09/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>6</TD></TR><TR><TD>1001700</TD><TD>10</TD><TD>72320.75</TD><TD>24/12/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>7</TD></TR><TR><TD>1001700</TD><TD>30</TD><TD>69285.18</TD><TD>20/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>8</TD></TR><TR><TD>1001700</TD><TD>50</TD><TD>69285.18</TD><TD>20/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>9</TD></TR><TR><TD>1001700</TD><TD>60</TD><TD>69285.18</TD><TD>30/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>10</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>69285.18</TD><TD>30/08/2017 00:00</TD><TD>24/09/2017 00:00</TD><TD>11</TD></TR><TR><TD>1001700</TD><TD>96</TD><TD>69285.18</TD><TD>24/09/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>12</TD></TR><TR><TD>1001700</TD><TD>98</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>13</TD></TR><TR><TD>1001700</TD><TD>100</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>14</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>15</TD></TR><TR><TD>1001700</TD><TD>107</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>16</TD></TR><TR><TD>1001700</TD><TD>110</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>17</TD></TR><TR><TD>1001700</TD><TD>120</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>18</TD></TR><TR><TD>1001700</TD><TD>130</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>19</TD></TR><TR><TD>1001700</TD><TD>134</TD><TD>69285.18</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>20</TD></TR><TR><TD>1001700</TD><TD>136</TD><TD>69285.18</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>21</TD></TR><TR><TD>1001700</TD><TD>137</TD><TD>800000.00</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>22</TD></TR><TR><TD>1001700</TD><TD>139</TD><TD>800000.00</TD><TD>25/12/2017 00:00</TD><TD>26/12/2017 00:00</TD><TD>23</TD></TR><TR><TD>1001700</TD><TD>140</TD><TD>800000.00</TD><TD>26/12/2017 00:00</TD><TD>26/12/2017 00:00</TD><TD>24</TD></TR><TR><TD>1001700</TD><TD>141</TD><TD>69285.18</TD><TD>26/12/2017 00:00</TD><TD>04/01/2018 00:00</TD><TD>25</TD></TR><TR><TD>1001700</TD><TD>142</TD><TD>69285.18</TD><TD>04/01/2018 00:00</TD><TD>14/01/2018 00:00</TD><TD>26</TD></TR><TR><TD>1001700</TD><TD>160</TD><TD>69285.18</TD><TD>14/01/2018 00:00</TD><TD>01/01/2999 00:00</TD><TD>27</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to present the amount of time there was a change in the <SPAN>contract&nbsp;</SPAN>information:</P><OL><LI>When there is a change for a lower status (change line number 2,7,15)</LI><LI>When there is an amount of change (lower or higher) (change line number 2,8,22,25)</LI></OL><P>I also need to summarize the number of times for each change listed above…</P><P>Any suggestions?</P><P>&nbsp;</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT Odelya 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1590581#M738391 <P>Hi</P><P>This is my data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Contract</TD><TD>Status</TD><TD>AMOUNT</TD><TD>STATUS_DATE_From</TD><TD>STATUS_DATE_Next</TD><TD>Change Number</TD></TR><TR><TD>1001700</TD><TD>10</TD><TD>-287110.56</TD><TD>09/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>1</TD></TR><TR><TD>1001700</TD><TD>5</TD><TD>72320.75</TD><TD>20/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>2</TD></TR><TR><TD>1001700</TD><TD>50</TD><TD>72320.75</TD><TD>20/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>3</TD></TR><TR><TD>1001700</TD><TD>60</TD><TD>72320.75</TD><TD>30/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>4</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>72320.75</TD><TD>30/08/2017 00:00</TD><TD>24/09/2017 00:00</TD><TD>5</TD></TR><TR><TD>1001700</TD><TD>96</TD><TD>72320.75</TD><TD>24/09/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>6</TD></TR><TR><TD>1001700</TD><TD>10</TD><TD>72320.75</TD><TD>24/12/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>7</TD></TR><TR><TD>1001700</TD><TD>30</TD><TD>69285.18</TD><TD>20/08/2017 00:00</TD><TD>20/08/2017 00:00</TD><TD>8</TD></TR><TR><TD>1001700</TD><TD>50</TD><TD>69285.18</TD><TD>20/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>9</TD></TR><TR><TD>1001700</TD><TD>60</TD><TD>69285.18</TD><TD>30/08/2017 00:00</TD><TD>30/08/2017 00:00</TD><TD>10</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>69285.18</TD><TD>30/08/2017 00:00</TD><TD>24/09/2017 00:00</TD><TD>11</TD></TR><TR><TD>1001700</TD><TD>96</TD><TD>69285.18</TD><TD>24/09/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>12</TD></TR><TR><TD>1001700</TD><TD>98</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>13</TD></TR><TR><TD>1001700</TD><TD>100</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>14</TD></TR><TR><TD>1001700</TD><TD>90</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>15</TD></TR><TR><TD>1001700</TD><TD>107</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>16</TD></TR><TR><TD>1001700</TD><TD>110</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>17</TD></TR><TR><TD>1001700</TD><TD>120</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>24/12/2017 00:00</TD><TD>18</TD></TR><TR><TD>1001700</TD><TD>130</TD><TD>69285.18</TD><TD>24/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>19</TD></TR><TR><TD>1001700</TD><TD>134</TD><TD>69285.18</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>20</TD></TR><TR><TD>1001700</TD><TD>136</TD><TD>69285.18</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>21</TD></TR><TR><TD>1001700</TD><TD>137</TD><TD>800000.00</TD><TD>25/12/2017 00:00</TD><TD>25/12/2017 00:00</TD><TD>22</TD></TR><TR><TD>1001700</TD><TD>139</TD><TD>800000.00</TD><TD>25/12/2017 00:00</TD><TD>26/12/2017 00:00</TD><TD>23</TD></TR><TR><TD>1001700</TD><TD>140</TD><TD>800000.00</TD><TD>26/12/2017 00:00</TD><TD>26/12/2017 00:00</TD><TD>24</TD></TR><TR><TD>1001700</TD><TD>141</TD><TD>69285.18</TD><TD>26/12/2017 00:00</TD><TD>04/01/2018 00:00</TD><TD>25</TD></TR><TR><TD>1001700</TD><TD>142</TD><TD>69285.18</TD><TD>04/01/2018 00:00</TD><TD>14/01/2018 00:00</TD><TD>26</TD></TR><TR><TD>1001700</TD><TD>160</TD><TD>69285.18</TD><TD>14/01/2018 00:00</TD><TD>01/01/2999 00:00</TD><TD>27</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to present the amount of time there was a change in the <SPAN>contract&nbsp;</SPAN>information:</P><OL><LI>When there is a change for a lower status (change line number 2,7,15)</LI><LI>When there is an amount of change (lower or higher) (change line number 2,8,22,25)</LI></OL><P>I also need to summarize the number of times for each change listed above…</P><P>Any suggestions?</P><P>&nbsp;</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1590581#M738391 Odelya 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1590587#M738392 <P>Hi,</P><P>In the preceding load of your load statement try to add:</P><LI-CODE lang="markup">LOAD *, if(Status&lt;Previous(Status),1,0) as FL_change, if(rowno()&gt;1 and AMOUNT&lt;&gt;Previous(AMOUNT),1,0) as FL_Amount</LI-CODE> Tue, 11 Jun 2019 16:54:11 GMT https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1590587#M738392 sergio0592 2019-06-11T16:54:11Z https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1591468#M738393 <P>Thank you!</P> Thu, 13 Jun 2019 09:38:22 GMT https://community.qlik.com/t5/QlikView/Find-and-summerize-changes-in-data-set/m-p/1591468#M738393 Odelya 2019-06-13T09:38:22Z