https://community.qlik.com/t5/App-Development/Count-cumulative-historical-values-based-on-conditions/m-p/1620670#M46208 <P>Hi everyone,&nbsp;</P><P>I have historical daily data of hours per day based on manual entry so the number can be 0 to 24 hours.</P><P>I would like to count how many historical days starting with today that the hours listed is greater than 0 and all in a row without a 0.</P><P>File attached.</P><P>For context:&nbsp; this is a natural gas well that has been "down" i.e. no production for 192 days and I would like to reflect this in a KPI.</P><P>Thanks in advance! I have researched the boards but haven't had any luck so far.</P> Thu, 05 Sep 2019 16:25:49 GMT AR_2019 2019-09-05T16:25:49Z https://community.qlik.com/t5/App-Development/Count-cumulative-historical-values-based-on-conditions/m-p/1620670#M46208 <P>Hi everyone,&nbsp;</P><P>I have historical daily data of hours per day based on manual entry so the number can be 0 to 24 hours.</P><P>I would like to count how many historical days starting with today that the hours listed is greater than 0 and all in a row without a 0.</P><P>File attached.</P><P>For context:&nbsp; this is a natural gas well that has been "down" i.e. no production for 192 days and I would like to reflect this in a KPI.</P><P>Thanks in advance! I have researched the boards but haven't had any luck so far.</P> Thu, 05 Sep 2019 16:25:49 GMT https://community.qlik.com/t5/App-Development/Count-cumulative-historical-values-based-on-conditions/m-p/1620670#M46208 AR_2019 2019-09-05T16:25:49Z