Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 

Advice on working out/displaying time spent in a particular state using timestamps for very large dataset

Hello everyone,

I'm really stuck on where to start with this one - hoping somebody can share some wisdom!

Basically, we have machines that run all day and flip between various states - sometimes as often as every minute. This is tracked via a timestamp and state code every time it changes - something like this:



Machine101/04/2016 01:37:505Auto Clean Mode Active
Machine101/04/2016 01:43:0110Idle Mode
Machine101/04/2016 01:44:0110 Idle Mode
Machine101/04/2016 01:45:004Printing Mode Active
Machine101/04/2016 01:45:042Homing Mode Active
Machine101/04/2016 01:45:1210Idle Mode
Machine101/04/2016 01:46:004Printing Mode Active
Machine101/04/2016 01:46:1410Idle Mode

I want to display this in a format that achieves the same sort of thing as this:


So eventually, I want to work out for each machine, how long per day they spent in each particular state (there are approximately 5 different states).

One of the major sticking points however is the sheer volume of data - there will be up to 200 machines and each one can have records throughout the day, changing states up to every few seconds. This will also increase in the future as more machines are added so the method chosen needs to be very performance optimised. Ideally, most of the hard work should be done in the script to ensure that user response time isn't massively affected.

Does anyone have any advice on the best way to approach this? Also, does a pie chart seem the best way to go for displaying the results?

Thank you in advance!

0 Replies