topic Max Number, Others and Sub-Totals in QlikView https://community.qlik.com/t5/QlikView/Max-Number-Others-and-Sub-Totals/m-p/194330#M55281 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>This is a slight variation to the the post by Nigel West (http://community.qlik.com/forums/p/21096/80926.aspx#80926).</P><P>I have a straight table in which i would like to display the top 10 Stock items by Value. Currently i've set up the straight table to show Stock Items by Total Value in descending order and set the max visible number to 10.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-754_sourceID:754" /></P><P></P><P>My problems are:</P><P>1. I would like to see a sum of the top 10 in both expression columns. Currently I can see a total of ALL and a total of ALL that are not displayed (Others), I want to see what IS displayed.</P><P>2. I would like to add a row number to my chart, but when i use rowno(total), i experience the same problem as federico as seen here (http://community.qlik.com/forums/p/18012/70446.aspx#70446)</P><P>I would appreciate any help. Many thanks.</P></BODY></HTML> Tue, 22 Dec 2009 07:32:22 GMT 2009-12-22T07:32:22Z Max Number, Others and Sub-Totals https://community.qlik.com/t5/QlikView/Max-Number-Others-and-Sub-Totals/m-p/194330#M55281 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>This is a slight variation to the the post by Nigel West (http://community.qlik.com/forums/p/21096/80926.aspx#80926).</P><P>I have a straight table in which i would like to display the top 10 Stock items by Value. Currently i've set up the straight table to show Stock Items by Total Value in descending order and set the max visible number to 10.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-754_sourceID:754" /></P><P></P><P>My problems are:</P><P>1. I would like to see a sum of the top 10 in both expression columns. Currently I can see a total of ALL and a total of ALL that are not displayed (Others), I want to see what IS displayed.</P><P>2. I would like to add a row number to my chart, but when i use rowno(total), i experience the same problem as federico as seen here (http://community.qlik.com/forums/p/18012/70446.aspx#70446)</P><P>I would appreciate any help. Many thanks.</P></BODY></HTML> Tue, 22 Dec 2009 07:32:22 GMT https://community.qlik.com/t5/QlikView/Max-Number-Others-and-Sub-Totals/m-p/194330#M55281 2009-12-22T07:32:22Z Max Number, Others and Sub-Totals https://community.qlik.com/t5/QlikView/Max-Number-Others-and-Sub-Totals/m-p/194331#M55282 <HTML><HEAD></HEAD><BODY><P>Hi Matt,</P><P>see the attached example for help.</P><P>Merry Christmas!</P><P>Rainer</P></BODY></HTML> Tue, 22 Dec 2009 16:15:37 GMT https://community.qlik.com/t5/QlikView/Max-Number-Others-and-Sub-Totals/m-p/194331#M55282 2009-12-22T16:15:37Z