Grouping by consecutive field/column value

kdaniels-obrien — Sat, 16 Nov 2024 03:45:11 GMT

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

Re: Grouping by consecutive field/column value

Taoufiq_Zarra — Tue, 24 Dec 2019 10:28:31 GMT

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

Re: Grouping by consecutive field/column value

lorenzoconforti — Tue, 24 Dec 2019 11:24:21 GMT

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

topic Re: Grouping by consecutive field/column value in App Development

Grouping by consecutive field/column value

Re: Grouping by consecutive field/column value

Re: Grouping by consecutive field/column value