topic Rankings Help in QlikView https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497862#M689982 <HTML><HEAD></HEAD><BODY><P>I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....</P><P></P><P>However,&nbsp; the trick is getting the remaining customers as cumulative sub-total within the total (see table below)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" width="64">Rank</TD><TD width="64">Customer </TD><TD width="64">Sales</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">2</TD><TD>b</TD><TD align="right">9</TD></TR><TR><TD align="right" height="20">3</TD><TD>c</TD><TD align="right">8</TD></TR><TR><TD align="right" height="20">4</TD><TD>de</TD><TD align="right">7</TD></TR><TR><TD align="right" height="20">5</TD><TD>fg</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">6</TD><TD>Others</TD><TD align="right">10</TD></TR><TR><TD height="20">Total</TD><TD align="right">50</TD><TD></TD></TR></TBODY></TABLE><P></P><P>I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.</P><P></P><P>Any help is greatly appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Nov 2013 10:19:22 GMT 2013-11-08T10:19:22Z Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497862#M689982 <HTML><HEAD></HEAD><BODY><P>I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....</P><P></P><P>However,&nbsp; the trick is getting the remaining customers as cumulative sub-total within the total (see table below)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192px;"><TBODY><TR><TD height="20" width="64">Rank</TD><TD width="64">Customer </TD><TD width="64">Sales</TD></TR><TR><TD align="right" height="20">1</TD><TD>a</TD><TD align="right">10</TD></TR><TR><TD align="right" height="20">2</TD><TD>b</TD><TD align="right">9</TD></TR><TR><TD align="right" height="20">3</TD><TD>c</TD><TD align="right">8</TD></TR><TR><TD align="right" height="20">4</TD><TD>de</TD><TD align="right">7</TD></TR><TR><TD align="right" height="20">5</TD><TD>fg</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">6</TD><TD>Others</TD><TD align="right">10</TD></TR><TR><TD height="20">Total</TD><TD align="right">50</TD><TD></TD></TR></TBODY></TABLE><P></P><P>I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.</P><P></P><P>Any help is greatly appreciated.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 08 Nov 2013 10:19:22 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497862#M689982 2013-11-08T10:19:22Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497863#M689983 <HTML><HEAD></HEAD><BODY><P>try using dimension limits .</P><P>Else, please attach the qvw document.</P></BODY></HTML> Fri, 08 Nov 2013 10:49:36 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497863#M689983 2013-11-08T10:49:36Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497864#M689984 <HTML><HEAD></HEAD><BODY><P>Use Dimension Limits, that´s why they´re were made <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 08 Nov 2013 11:30:39 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497864#M689984 Clever_Anjos 2013-11-08T11:30:39Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497865#M689985 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can also create a Calculated Dimension:</P><P><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">=</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: blue; font-size: 10pt;">Aggr</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: blue; font-size: 10pt;">If</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: blue; font-size: 10pt;">Rank</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: blue; font-size: 10pt;">Sum</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">(</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 10pt;">[Sales]</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">))&lt;5</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">, </SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 10pt;">FABRICANT_LName</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">, 'Others'),&nbsp; </SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: maroon; font-size: 10pt;">FABRICANT_LName</SPAN><SPAN lang="EN-US" style="font-family: 'Courier New'; color: black; font-size: 10pt;">) </SPAN></P><P></P><P>Your expression will be Sum(Sales)</P><P></P><P>Fabrice</P></BODY></HTML> Fri, 08 Nov 2013 11:46:05 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497865#M689985 2013-11-08T11:46:05Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497866#M689986 <HTML><HEAD></HEAD><BODY><P>please look at file I have attach</P></BODY></HTML> Fri, 08 Nov 2013 12:18:40 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497866#M689986 annafuksa1 2013-11-08T12:18:40Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497867#M689987 <HTML><HEAD></HEAD><BODY><P>thanks this is what I was looking for !!!</P></BODY></HTML> Fri, 08 Nov 2013 13:37:36 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497867#M689987 2013-11-08T13:37:36Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497868#M689988 <HTML><HEAD></HEAD><BODY><P><BR />no attachment <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 08 Nov 2013 13:38:00 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497868#M689988 2013-11-08T13:38:00Z Re: Rankings Help https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497869#M689989 <HTML><HEAD></HEAD><BODY><P>not working ? or you cant open ?</P></BODY></HTML> Fri, 08 Nov 2013 14:35:29 GMT https://community.qlik.com/t5/QlikView/Rankings-Help/m-p/497869#M689989 annafuksa1 2013-11-08T14:35:29Z