Take time to delete

[Paknanarn23]

I want to subtract the Start Time of the next WO from the null WO with the Start Time of the previous WO, what should I do?

[udit_k]

using below function and using offset parameter we could achieve this :-

Below - chart function | Qlik Sense on Windows Help

[Paknanarn23]

I tried this but it doesn't value my condition. I want a value where, if Value = 0, take the start Time of the WO next to the WO that is equal to 0, subtract the previous value greater than 0.

[udit_k]

Start time could be valuate using above function .

if(isnull(StartTime),below(StartTime,0,1),StartTime)

To subtract value with next to previous one , we need to have both above and below records of the row where value is 0.

if (isnull(sum(NbSales)),Rangesum( Above(Sum( NbSales),0, 1))-Rangesum( below(Sum( NbSales),0, 1)),sum(NbSales))

[Paknanarn23]

I made an example for you to look at in excel. in what I want

[udit_k]

This should work :-

if (isnull(StartTime),( below(StartTime,0, 1))-( Above(StartTime,0, 1)),StartTime)

[Paknanarn23]

Thank you for trying to help me. But when I use this code The results are not as desired.