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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kdaniels-obrien
Partner - Creator
Partner - Creator

Grouping by consecutive field/column value

Hi, 

I am trying to group some of my data based off consecutive values in another field. For example, a machine is running from 8:02-8:04 and then the machine is down (not running for whatever reason) starting at 8:05. For example purposes, lets say the machine is down for 5 minutes, until 8:10.  I would like to group the duration the machine is running and when it is down so I can count how many times the machine breaks down for a selected time period.  I would also like to set start and end times of each duration for other charts.  I am relatively new to Qlik and I have seen things like ABOVE functions but would like to see it using my use case.  

 
 
 

Note:  In the example data below, change is not a real field in my data I just put this in here to highlight when I expect to see a change.

Time:          Status:          change:

8:02             Running       No

8:03             Running       No         

8:04             Running      No

8:05             Running      Yes

sample for QC.png 

 

Labels (2)
2 Replies
Taoufiq_Zarra

Hi, can you share a sample data and the expected output of this sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
lorenzoconforti
Specialist II
Specialist II

Rather than solving this in a chart, I would work on the loading script and add in there the extra field(s) you need. It should then be easier to display the info in the chart