topic Re: Sorting Issue in QlikView https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649857#M237698 <HTML><HEAD></HEAD><BODY><P>is dimension limit on second dim?</P><P>did you check global grouping?</P></BODY></HTML> Fri, 17 Oct 2014 10:15:30 GMT maxgro 2014-10-17T10:15:30Z Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649854#M237695 <HTML><HEAD></HEAD><BODY><P>I have a chart with two dimensions and two expressions such as:</P><P>Dimension1: ID</P><P>Dimension2: Group</P><P>Expression1: Current Year Sales</P><P>Expression2 : Previous Year Sales</P><P></P><P>I have to show top 25 values based on the current year sales in the chart.</P><P>I did it by restricting Dimension limits to show largest 25 values and sorted the current year column in descending order.</P><P></P><P>But the problem is an ID A comes at the first postion as well as the 26th position in the chart. The only difference is in the Group values. The A at the 26th position shouldn't show up.</P><P></P><P>Please help!!!!</P></BODY></HTML> Fri, 17 Oct 2014 09:53:29 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649854#M237695 2014-10-17T09:53:29Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649855#M237696 <HTML><HEAD></HEAD><BODY><P>Could you send a sample of your development?</P></BODY></HTML> Fri, 17 Oct 2014 10:04:08 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649855#M237696 d_pranskus 2014-10-17T10:04:08Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649856#M237697 <HTML><HEAD></HEAD><BODY><P>This seems to be expression issue and not the sorting issue. Can you check your expression in any other object like straight table or pivot.</P><P></P><P>Thanks,</P><P>Singh</P></BODY></HTML> Fri, 17 Oct 2014 10:08:24 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649856#M237697 2014-10-17T10:08:24Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649857#M237698 <HTML><HEAD></HEAD><BODY><P>is dimension limit on second dim?</P><P>did you check global grouping?</P></BODY></HTML> Fri, 17 Oct 2014 10:15:30 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649857#M237698 maxgro 2014-10-17T10:15:30Z Re: Sorting Issue https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649858#M237699 <HTML><HEAD></HEAD><BODY><P>Hi, try to limit the number of rows with the next option:</P></BODY></HTML> Fri, 24 Oct 2014 16:46:53 GMT https://community.qlik.com/t5/QlikView/Sorting-Issue/m-p/649858#M237699 PabloOrtiz 2014-10-24T16:46:53Z