topic Re: top values for region in QlikView https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345211#M127623 <HTML><HEAD></HEAD><BODY><P>Try creating a straight table with dimensions Year and Subject, use</P><P>=sum(Marks) </P><P>as expression.</P><P></P><P>Assuming you are using QV11, go to dimension limits in chart properties and enable option 'Restrict which values are displayed..' - 'show only largest 1 value' for the second dimension.</P></BODY></HTML> Wed, 11 Jul 2012 10:30:36 GMT swuehl 2012-07-11T10:30:36Z top values for region https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345210#M127622 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Below is my table </P><P>Year, Subject , Marks</P><P>&nbsp;&nbsp;&nbsp; 2011, ABC, 30</P><P>&nbsp;&nbsp;&nbsp; 2011, ABC, 23</P><P>&nbsp;&nbsp;&nbsp; 2011, ABC, 23</P><P>&nbsp;&nbsp;&nbsp; 2011, ABC, 43</P><P>&nbsp;&nbsp;&nbsp; 2011, GEF, 12</P><P>&nbsp;&nbsp;&nbsp; 2011, GEF, 43</P><P>&nbsp;&nbsp;&nbsp; 2011, GEFD, 12</P><P>&nbsp;&nbsp;&nbsp; 2011, GEF, 32</P><P>&nbsp;&nbsp;&nbsp; 2012, ABC, 43</P><P>&nbsp;&nbsp;&nbsp; 2012, ABC, 54</P><P>&nbsp;&nbsp;&nbsp; 2012, GEF, 12</P><P>&nbsp;&nbsp;&nbsp; 2012, GEF, 54</P><P>&nbsp;&nbsp;&nbsp; 2012, GEFD, 54</P><P></P><P>i need to display jst year ,top subject based on sum and sum of marks </P><P>2011&nbsp;&nbsp;&nbsp; ABC 76</P><P>2012&nbsp;&nbsp;&nbsp; ABC 97</P><P>in a straight table </P></BODY></HTML> Wed, 11 Jul 2012 10:07:45 GMT https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345210#M127622 2012-07-11T10:07:45Z Re: top values for region https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345211#M127623 <HTML><HEAD></HEAD><BODY><P>Try creating a straight table with dimensions Year and Subject, use</P><P>=sum(Marks) </P><P>as expression.</P><P></P><P>Assuming you are using QV11, go to dimension limits in chart properties and enable option 'Restrict which values are displayed..' - 'show only largest 1 value' for the second dimension.</P></BODY></HTML> Wed, 11 Jul 2012 10:30:36 GMT https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345211#M127623 swuehl 2012-07-11T10:30:36Z Re: top values for region https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345212#M127624 <HTML><HEAD></HEAD><BODY><P>I am not getting what i need with it </P><P>iam getting </P><P>2011 others 218</P><P>2012 others 217</P></BODY></HTML> Wed, 11 Jul 2012 10:56:14 GMT https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345212#M127624 2012-07-11T10:56:14Z Re: top values for region https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345213#M127625 <HTML><HEAD></HEAD><BODY><P>Try unchecking the 'Show Others' option on the dimension limits tab.</P><P></P><P></P></BODY></HTML> Wed, 11 Jul 2012 10:57:25 GMT https://community.qlik.com/t5/QlikView/top-values-for-region/m-p/345213#M127625 swuehl 2012-07-11T10:57:25Z