display the customers who passed 3 consecutive validated orders

[paschpower]

Hi Everybody,

I have a great business question and huge need to find help:

I would like to know the means to display the customers who passed 3 consecutive validated orders and the fourth following order being cancelled.

Here is my data screenshot:

Thank you for your time

Pacshpower!

[paschpower]

Hi again,

I will welcome an SQL script, if possible, to deal with this need.

Thank you again for your support.

paschpower!

[oknotsen]

Think you took a wrong turn somewhere and ended here by accident, because this is not the SQL support forum.

We support only Qlik products here.

Maybe try here:

Google search on SQL support