Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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.