topic Identifying trends in QlikView in QlikView https://community.qlik.com/t5/QlikView/Identifying-trends-in-QlikView/m-p/406288#M151156 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Suppose I have a pharmacy dataset that has the number of UNITS prescribed for each WEEK.</P><P></P><P>I'm trying to apply some statistical rules to the dataset so that QlikView flags up any seemingly rouge values or trends.<BR />(Nelson rules, if you are interested - <A href="http://en.wikipedia.org/wiki/Nelson_rules">http://en.wikipedia.org/wiki/Nelson_rules</A>)</P><P></P><P>Can someone give me a clue as to how I might get QlikView to look at the dataset and spot if:</P><P></P><UL><LI> six weeks figures in a row show an increase (ie 25, 34, 17, <EM><STRONG>25, 29, 32, 37, 41, 42</STRONG></EM>, 37).</LI></UL><P></P><P>Many thanks in advance,</P><P></P><P>Robin</P></BODY></HTML> Tue, 06 Nov 2012 10:21:39 GMT 2012-11-06T10:21:39Z Identifying trends in QlikView https://community.qlik.com/t5/QlikView/Identifying-trends-in-QlikView/m-p/406288#M151156 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>Suppose I have a pharmacy dataset that has the number of UNITS prescribed for each WEEK.</P><P></P><P>I'm trying to apply some statistical rules to the dataset so that QlikView flags up any seemingly rouge values or trends.<BR />(Nelson rules, if you are interested - <A href="http://en.wikipedia.org/wiki/Nelson_rules">http://en.wikipedia.org/wiki/Nelson_rules</A>)</P><P></P><P>Can someone give me a clue as to how I might get QlikView to look at the dataset and spot if:</P><P></P><UL><LI> six weeks figures in a row show an increase (ie 25, 34, 17, <EM><STRONG>25, 29, 32, 37, 41, 42</STRONG></EM>, 37).</LI></UL><P></P><P>Many thanks in advance,</P><P></P><P>Robin</P></BODY></HTML> Tue, 06 Nov 2012 10:21:39 GMT https://community.qlik.com/t5/QlikView/Identifying-trends-in-QlikView/m-p/406288#M151156 2012-11-06T10:21:39Z