Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
paschpower
Contributor II
Contributor II

display the customers who passed 3 consecutive validated orders

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!

2 Replies
paschpower
Contributor II
Contributor II
Author

Hi again,

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

Thank you again for your support.

paschpower!

oknotsen
Master III
Master III

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

May you live in interesting times!