Discussion board where members can get started with QlikView.
I've a requirement to create a new column based on subtracting 2 date columns
In above image, I'd like to get Turn around time by doing 10:30 - 10-45 and then 12:17 - 12:44
To create a new column with this...
Tried peek, above rangesum but doesn't seem to work.
Can anyone please tell me how to get TAT from previous time to current time in next row?
Maybe I found the solution...
Divided into 3 exp. not ideal but works
Exp1: above(Total (Column2))-(Column2)
Exp:2: below(Total (Column1))-(Column1)
Final Exp: below(Total ([Exp1]))-([Exp2])
View solution in original post