topic Re: Syntax help in QlikView https://community.qlik.com/t5/QlikView/Syntax-help/m-p/1231747#M865706 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>Please review attachment. The main idea is to sort the data set and use Previous function to generate rank.</P><P></P><P>Hope it will help</P></BODY></HTML> Thu, 08 Dec 2016 21:03:20 GMT bgerchikov 2016-12-08T21:03:20Z Syntax help https://community.qlik.com/t5/QlikView/Syntax-help/m-p/1231746#M865705 <HTML><HEAD></HEAD><BODY><P>I have 3 tables, see below and attached. I need create a table of Alerts (first table) with a&nbsp; Rank and Indicator (If statement). I'm</P><P>going to filter on Rank =1. I've been working on this for a while and keep running into issues. The latest attemp is attached but is missing the attempt for Survey2a.</P><P></P><P><SPAN style="font-size: 8pt;">Indicator =&nbsp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">AlertDate</SPAN><SPAN style="font-size: 8pt;"> - </SPAN><SPAN style="color: #800000; font-size: 8pt;">Survey1A_Date</SPAN><SPAN style="font-size: 8pt;"> &lt;= 10, 'Y', 'N') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Survey1a_Indicator </SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="font-size: 8pt;">Indicator =&nbsp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">IF</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">AlertDate</SPAN><SPAN style="font-size: 8pt;"> - </SPAN><SPAN style="color: #800000; font-size: 8pt;">Survey2A_Date</SPAN><SPAN style="font-size: 8pt;"> &lt;= 10, 'Y', 'N') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Survey2a_Indicator</SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 8pt;">Rank = Partition by Memberid, /* I believe I need to inlcude incase there are duplicate entries but name Survey name differes Name*/ ,AlertDate, order by SurveyIndicator desc, Survey1aDate</SPAN></P><P>My output should look like below: All data from the alert table</P><P></P><P>Output:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maybe add Ranks in script, not sure what would be best. Eventually will filter of Rank = 1</P><P>Memberid&nbsp; AlertDate&nbsp;&nbsp;&nbsp; TypeOfAlert&nbsp;&nbsp;&nbsp; Survey1a_Indicator&nbsp;&nbsp;&nbsp;&nbsp; Survey2a_Indicator&nbsp; /*Survey1aRank*//* Survey2aRank*/</P><P>&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/20/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/11/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp; /* Blank:Survey1a date is less than AlertDate*/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/12/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 (latest survey date)</P><P>&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/30/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/30/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/5/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Red&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>/*Skipping Rows 7-9*/</P><P>&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/10/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Blank:Survey1a date is less than AlertDate*/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>/* If Memberid on both tables,&nbsp; I need to adjust rank to include if applicable */&nbsp;&nbsp;&nbsp; </P><P>11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/1/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /* Represents no Survey data but Alert data*/</P><P>13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Alert:<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AlertPK</SPAN></TD><TD style="border: 0px black; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Memberid</SPAN></TD><TD style="border: 0px black; border-image: none;" width="101"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">AlertDate</SPAN></TD><TD style="border: 0px black; border-image: none;" width="83"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">TypeOfAlert</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/10/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">101</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/20/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">102</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/11/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">103</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/12/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">104</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/30/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">105</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/10/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">106</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/5/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">107</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/6/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">108</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/7/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Red</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">109</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/8/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">110</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/10/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">111</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4/1/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Green</SPAN></TD></TR></TBODY></TABLE><P></P><P>Survey1a:<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="309"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Memberid</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1Date</SPAN></TD><TD style="border: 0px black; border-image: none;" width="88"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Region</SPAN></TD><TD style="border: 0px black; border-image: none;" width="64"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Name</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/11/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/22/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/1/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/25/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/1/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4/1/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">East</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey1</SPAN></TD></TR></TBODY></TABLE><P></P><P>Survey2a:<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="361"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="72"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Memberid</SPAN></TD><TD style="border: 0px black; border-image: none;" width="85"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2Date</SPAN></TD><TD style="border: 0px black; border-image: none;" width="93"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Region</SPAN></TD><TD style="border: 0px black; border-image: none;" width="111"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Name</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/6/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10/1/2015</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/19/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/9/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1/11/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR><TR><TD align="right" height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4/1/2016</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">West</SPAN></TD><TD style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Survey2</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Syntax-help/m-p/1231746#M865705 Anonymous 2020-11-25T16:16:04Z Re: Syntax help https://community.qlik.com/t5/QlikView/Syntax-help/m-p/1231747#M865706 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>Please review attachment. The main idea is to sort the data set and use Previous function to generate rank.</P><P></P><P>Hope it will help</P></BODY></HTML> Thu, 08 Dec 2016 21:03:20 GMT https://community.qlik.com/t5/QlikView/Syntax-help/m-p/1231747#M865706 bgerchikov 2016-12-08T21:03:20Z