topic Re: Straight Table..sorting in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506284#M189278 <HTML><HEAD></HEAD><BODY><P>select sort by expression and provide sales expression.</P></BODY></HTML> Tue, 25 Jun 2013 12:12:37 GMT 2013-06-25T12:12:37Z Straight Table..sorting https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506283#M189277 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a straight table where i have three dimensions Product Group, Pack Size,UOM...</P><P>and sales comparison is der...</P><P>product group may have product of different pack size....</P><P></P><P>The problem comes for sorting i am able to sort it at product group level but if a certain pack size has less sales it also appears in top 20 as the overall product group sales is high i want to sort the table according to purely sales...</P><P></P><P>I am attaching excel file for an idea...</P><P></P><P>Thanks and Regards,</P><P>Rohit</P></BODY></HTML> Tue, 25 Jun 2013 12:03:04 GMT https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506283#M189277 rohitians 2013-06-25T12:03:04Z Re: Straight Table..sorting https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506284#M189278 <HTML><HEAD></HEAD><BODY><P>select sort by expression and provide sales expression.</P></BODY></HTML> Tue, 25 Jun 2013 12:12:37 GMT https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506284#M189278 2013-06-25T12:12:37Z Re: Straight Table..sorting https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506285#M189279 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I did that ....</P><P>Go through the excel file..</P><P></P><P>Thanks,</P><P>Rohit</P></BODY></HTML> Tue, 25 Jun 2013 12:17:49 GMT https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506285#M189279 rohitians 2013-06-25T12:17:49Z Re: Straight Table..sorting https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506286#M189280 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>Ur Product Group "I' is gaving 2 PackSize.so it is comming like..</P><P><IMG __jive_id="43217" class="jive-image" alt="shorting 1.bmp" src="/legacyfs/online/43217_shorting 1.bmp" /></P><P></P><P>Pls do one thing in ur straight table go Properties &gt; Sort &gt; uncheck all columns sorting..just check 2013-14 column</P><P><IMG __jive_id="43218" class="jive-image-thumbnail jive-image" onclick="" alt="shorting.bmp" src="https://community.qlik.com/legacyfs/online/43218_shorting.bmp" width="450" /></P><P></P><P>Hope it will help u</P><P></P><P>regards-Bika</P></BODY></HTML> Tue, 25 Jun 2013 12:25:02 GMT https://community.qlik.com/t5/QlikView/Straight-Table-sorting/m-p/506286#M189280 2013-06-25T12:25:02Z