Hello everybody,
I have not worked so long with QlikView and need some help!
The point is that I have a machine that sets a timestamp at the beginning of a production cycle and another at the end of the production cycle.
The calculation of the production time per piece thus results from "ENDTIME-STARTTIME" - where ENDTIME and STARTTIME are the respective time stamps.
The problem is that Qlikview contains multiple identical STARTTIME records because of links to junk-related data. However, I would like to ignore these in my calculation because I want to calculate the actual production time of the machine.
My function looks like this:
sum (END_TIME-START_TIME)
But how do I get it now, that is checked first, whether START_TIME contains duplicate values and ignored if necessary. I know that the DISTINCT command offers a possibility, but the problem is that I can not make any changes in the script, but can only do calculations with charts and tables because I lack certain access rights.
Thanks in advance,
Dominic
