Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AR_2019
Contributor
Contributor
‎2019-09-05 12:25 PM

Count cumulative historical values based on conditions

Hi everyone, 

I have historical daily data of hours per day based on manual entry so the number can be 0 to 24 hours.

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.

File attached.

For context:  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.

Thanks in advance! I have researched the boards but haven't had any luck so far.

days_down.qvf
271 Views
0 Likes
0 Replies