topic Take time to delete in QlikView

Take time to delete

Paknanarn23 — Wed, 05 Jul 2023 08:21:22 GMT

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?

Re: Take time to delete

udit_k — Wed, 05 Jul 2023 08:40:34 GMT

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

Below - chart function | Qlik Sense on Windows Help

Re: Take time to delete

Paknanarn23 — Wed, 05 Jul 2023 09:01:23 GMT

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.

Re: Take time to delete

udit_k — Wed, 05 Jul 2023 09:30:49 GMT

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))

Re: Take time to delete

Paknanarn23 — Wed, 05 Jul 2023 09:38:46 GMT

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

Re: Take time to delete

udit_k — Wed, 05 Jul 2023 10:00:20 GMT

This should work :-

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

Re: Take time to delete

Paknanarn23 — Thu, 06 Jul 2023 01:51:10 GMT

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