topic Quartiling data in QlikView https://community.qlik.com/t5/QlikView/Quartiling-data/m-p/791791#M667567 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-size: 10pt; line-height: 1.5em;"> I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year".&nbsp;&nbsp; and join the quartile data to the right of the&nbsp; table (as below). Is this an Aggr function?</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px currentcolor; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">PRIMARY_TICKER</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="139">Metric</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="139">Conviction Sector description</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="117">Year</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="63">Data</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="63">Sector Quartile</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">000001.SZ</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.15</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000002.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.26</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000003.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.27</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000003.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.01</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">4</TD></TR></TBODY></TABLE><P></P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Many thanks in advance</P></BODY></HTML> Fri, 07 Nov 2014 17:24:51 GMT 2014-11-07T17:24:51Z Quartiling data https://community.qlik.com/t5/QlikView/Quartiling-data/m-p/791791#M667567 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-size: 10pt; line-height: 1.5em;"> I want to quartile a group of "Primary Tickers" against a "Conviction sector" and "Year".&nbsp;&nbsp; and join the quartile data to the right of the&nbsp; table (as below). Is this an Aggr function?</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px currentcolor; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="64">PRIMARY_TICKER</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="139">Metric</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="139">Conviction Sector description</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="117">Year</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="63">Data</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="63">Sector Quartile</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">000001.SZ</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.15</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000002.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.26</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">2</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000003.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.27</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1</TD></TR><TR style="border: 0px currentcolor; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="20" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">000003.SZ</SPAN></TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CROCI_INCL_LEASES</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">Oil</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">CY 2004</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">0.01</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">4</TD></TR></TBODY></TABLE><P></P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Many thanks in advance</P></BODY></HTML> Fri, 07 Nov 2014 17:24:51 GMT https://community.qlik.com/t5/QlikView/Quartiling-data/m-p/791791#M667567 2014-11-07T17:24:51Z Re: Quartiling data https://community.qlik.com/t5/QlikView/Quartiling-data/m-p/791792#M667568 <HTML><HEAD></HEAD><BODY><P><BR />anyone have any ideas on this one?</P><P></P><P><A href="https://community.qlik.com/qlik-users/96544">Gysbert Wassenaar</A></P></BODY></HTML> Mon, 10 Nov 2014 09:51:05 GMT https://community.qlik.com/t5/QlikView/Quartiling-data/m-p/791792#M667568 2014-11-10T09:51:05Z