Convoluted Cycle Time Report

Anonymous — Mon, 26 Jul 2010 20:50:24 GMT

I have 5 sets of start timestamp and end timestamp. I also have 5 sets of stop timestamp & restart timestamp which can occur between the start & end timestamps. I need to create a net cycle time report, which basically is below:

networkdays(start timestamp, end timestamp) - networkdays(stop timestamp, restart timestamp) (if stop & restart timestamps fall between start & end timestamp).

Is there a better way to write the above code than a big hairy if condition?

Thanks,

Dinesh.

topic Convoluted Cycle Time Report in QlikView

Convoluted Cycle Time Report