Count of times in back order

[LesJean]

Good morning Qlik community,

I have a special count to do and I need your insights to realise it.

First of all, here's a snipet of data to help you understand what I'm trying to do:

Week:            ID:  
2019-11-15       111
2019-11-15       222
2019-11-15       333
2019-11-08       111
2019-11-08       222
2019-11-01       333
2019-10-25       111

I'm trying to do a count of the number of time a product was on back order, but, if the product was on the back order report multiple weeks in a row, it counts as the same back order, so, in the sample of data presented above, the count i'm trying to do should return:

111 was on back order 2 times

222 was on back order 1 time

333 was on back order 2 times

Any help would be greatly appreciated,

Thank you,

LesJean

[sunny_talwar · Accepted solution]

I would address this by creating a flag on the back end of the application. Where you check if for the same ID, the previous date is within the 7 days or not. If it is not, flag it with 1, otherwise 0.