problem with table - Aggr, Sum, Timestamp

Tue, 09 Apr 2013 09:43:42 GMT

Hi... I need some help with a table.

a.) first is there another way to reduce "All Timeszamps" to Max and delete the null-Values?

(I already tried DISTINCT but it doesnt work and I already checked "hide null values")

b.) afterwards i want to calculate the time intervals between the 1st and 2nd Max-value (see time 1), between the 3rd and 4th (see time 2), and so on ..

-->watch out they have to build the intervall with the next MAX value within the same status (see time 4)

Thank you for your advice

topic problem with table - Aggr, Sum, Timestamp in QlikView

problem with table - Aggr, Sum, Timestamp