Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor II
Contributor II

Hi again,

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

Thank you again for your support.

paschpower!

Highlighted
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

Don't allow Perfection to be the enemy of Good Enough.
May you live in interesting times!