topic Rank function help in QlikView https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29166#M609765 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Currently my dimension is Debiteur and my expression is&nbsp;&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> <SPAN style="color: #333333;"><STRONG>=if(rank(Sum([VERKOPE BTW UITG]))&lt;10,sum({&lt;[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG]))</STRONG></SPAN></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></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">The above expression works fine . </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Know i want to remove the dimension&nbsp; DEBITEUR (this leaves no dimensions) and my expected output should be the sum of the top 10 values shown below</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Please assist</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 724px;"><TBODY><TR><TD height="18" style="border: 0.5pt solid gainsboro; border-image: none; background-color: #ccffff;" width="118"><STRONG style="color: #333333;">DEBITEUR</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; background-color: #ccffff;" width="606"><STRONG style="color: #333333;">=if(rank(Sum([VERKOPE BTW UITG]))&lt;10,sum({&lt;[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG]))</STRONG></TD></TR><TR><TD height="18" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><STRONG style="color: #000000;"> </STRONG></TD><TD style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black gainsboro gainsboro; background-color: whitesmoke;"><STRONG style="color: #000000;">-</STRONG></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (BK)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">31145318.74</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (BT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">28588550.14</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (DP)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">59725347.45</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (FY)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">45395466.76</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OL)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">41292023.36</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OR)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">40014475.08</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">32141113.1</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADREGSTELLINGS (OT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">24078.51</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 15 Feb 2018 09:00:18 GMT vvvvvvizard 2018-02-15T09:00:18Z Rank function help https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29166#M609765 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Currently my dimension is Debiteur and my expression is&nbsp;&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> <SPAN style="color: #333333;"><STRONG>=if(rank(Sum([VERKOPE BTW UITG]))&lt;10,sum({&lt;[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG]))</STRONG></SPAN></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></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">The above expression works fine . </SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Know i want to remove the dimension&nbsp; DEBITEUR (this leaves no dimensions) and my expected output should be the sum of the top 10 values shown below</SPAN></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">Please assist</SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 724px;"><TBODY><TR><TD height="18" style="border: 0.5pt solid gainsboro; border-image: none; background-color: #ccffff;" width="118"><STRONG style="color: #333333;">DEBITEUR</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; background-color: #ccffff;" width="606"><STRONG style="color: #333333;">=if(rank(Sum([VERKOPE BTW UITG]))&lt;10,sum({&lt;[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG]))</STRONG></TD></TR><TR><TD height="18" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><STRONG style="color: #000000;"> </STRONG></TD><TD style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black gainsboro gainsboro; background-color: whitesmoke;"><STRONG style="color: #000000;">-</STRONG></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (BK)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">31145318.74</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (BT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">28588550.14</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (DP)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">59725347.45</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (FY)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">45395466.76</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OL)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">41292023.36</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OR)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">40014475.08</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADOORPLASINGSKONTROLE (OT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">32141113.1</SPAN></TD></TR><TR><TD height="18" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333;">VOORRAADREGSTELLINGS (OT)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333;">24078.51</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 15 Feb 2018 09:00:18 GMT https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29166#M609765 vvvvvvizard 2018-02-15T09:00:18Z Re: Rank function help https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29167#M609766 <HTML><HEAD></HEAD><BODY><P>Should be just this</P><P></P><P><STRONG style="color: #ff0000;">Sum(Aggr(</STRONG></P><P><STRONG>If(Rank(Sum([VERKOPE BTW UITG]))&lt;10,sum({&lt;[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG])), <SPAN style="color: #ff0000;">DEBITEUR))</SPAN></STRONG></P></BODY></HTML> Thu, 15 Feb 2018 12:14:08 GMT https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29167#M609766 sunny_talwar 2018-02-15T12:14:08Z Re: Rank function help https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29168#M609767 <HTML><HEAD></HEAD><BODY><P>Alternatively we can put the condition in the set expression .</P><P></P><P></P><P><STRONG style="color: #333333; font-size: 12pt; font-family: Times New Roman;">sum({&lt;<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">DEBITEUR </SPAN> = {"=<STRONG style="color: #333333; font-size: 12pt; font-family: Times New Roman;">rank(Sum([VERKOPE BTW UITG]), 4)&lt;10</STRONG>"},[FIN JAAR]={2018} ,DEBITEURNO-={777777}&gt;} [VERKOPE BTW UITG])</STRONG></P><P></P><P></P><P></P><P><SPAN style="color: #333333; font-family: Times New Roman; font-size: 12pt;">Best Regards,</SPAN></P><P><SPAN style="color: #333333; font-family: Times New Roman; font-size: 12pt;">Vikraant</SPAN></P></BODY></HTML> Fri, 16 Feb 2018 10:18:50 GMT https://community.qlik.com/t5/QlikView/Rank-function-help/m-p/29168#M609767 vikraant 2018-02-16T10:18:50Z