Qlik Community

Qlik Sense App Development

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

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!