Hi everyone,
Suppose I have a pharmacy dataset that has the number of UNITS prescribed for each WEEK.
I'm trying to apply some statistical rules to the dataset so that QlikView flags up any seemingly rouge values or trends.
(Nelson rules, if you are interested - http://en.wikipedia.org/wiki/Nelson_rules)
Can someone give me a clue as to how I might get QlikView to look at the dataset and spot if:
- six weeks figures in a row show an increase (ie 25, 34, 17, 25, 29, 32, 37, 41, 42, 37).
Many thanks in advance,
Robin