topic TOP 100 in QlikView https://community.qlik.com/t5/QlikView/TOP-100/m-p/441003#M164407 <HTML><HEAD></HEAD><BODY><P>i hav 2 dimensions, branch and company and expression as</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FST_LOAN_AMT</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #800000; font-size: 8pt;">Denominator</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><BR /><BR /><SPAN style="font-size: 10pt;">branch is my 1st dimension, i want to show branchwise top 100 companies based on the amt, hw cn i do tht</SPAN><BR /><BR /> </SPAN></P></BODY></HTML> Wed, 05 Jun 2013 10:16:04 GMT 2013-06-05T10:16:04Z TOP 100 https://community.qlik.com/t5/QlikView/TOP-100/m-p/441003#M164407 <HTML><HEAD></HEAD><BODY><P>i hav 2 dimensions, branch and company and expression as</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">FST_LOAN_AMT</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #800000; font-size: 8pt;">Denominator</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><BR /><BR /><SPAN style="font-size: 10pt;">branch is my 1st dimension, i want to show branchwise top 100 companies based on the amt, hw cn i do tht</SPAN><BR /><BR /> </SPAN></P></BODY></HTML> Wed, 05 Jun 2013 10:16:04 GMT https://community.qlik.com/t5/QlikView/TOP-100/m-p/441003#M164407 2013-06-05T10:16:04Z