Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.


Stock break for 5 consecutive days

Hello community,

I'm struggling whith what seems to be a simple requirement.

I have a table with ArticleID, Date, Stock break date.

I need to count ArticleIDs where there was a stock break for more thank 5 consecutive days.

Thanks in advance.

1 Reply
Honored Contributor III

Re: Stock break for 5 consecutive days


Can you please provide a sample data set for this requirement. Well you can use group by to find the stock break count and then get the desired output.