topic Re: Filter and sort in pivot table in QlikView https://community.qlik.com/t5/QlikView/Filter-and-sort-in-pivot-table/m-p/388412#M491134 <HTML><HEAD></HEAD><BODY><P>Ideas anyone?</P></BODY></HTML> Mon, 10 Sep 2012 19:04:44 GMT 2012-09-10T19:04:44Z Filter and sort in pivot table https://community.qlik.com/t5/QlikView/Filter-and-sort-in-pivot-table/m-p/388411#M491133 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please see the attached sample file.</P><P></P><P>I'm desperately trying to achieve the following:</P><P></P><UL><LI>Filter the list of Partners/Clients by Total Share based on the input table on the right (see Min Share and Max Share) but I don't want the Total Share value to change. For example, at the moment when I manage to get down to the 37095/JDM combination I get Total Share of 100% rather than 0.73% - it looks like the Total Sales History is not correct here (this should always show the total Sales for the Client regardless of the Partner). Just to be clearer, if I select Min Share 70% and Max Share 100% I'd like to see the below:</LI></UL><TABLE><TBODY><TR><TD>Partner</TD><TD>Client</TD><TD>Opportunity Value</TD><TD>Total Sales with Partner</TD><TD>Total Sales History</TD><TD>Total Share</TD></TR><TR><TD>5849</TD><TD>DQATP OFYXUDVUOL ZRGRKXWMNKV / Hibyras</TD><TD>$31.485,00</TD><TD>$749,65</TD><TD>$749,65</TD><TD>100,00%</TD></TR><TR><TD>52747</TD><TD>JDM XHZUGEAS&nbsp; LYY / Gvqlcxk</TD><TD>$5.048,00</TD><TD>$3.805,71</TD><TD>$5.281,13</TD><TD>72,06%</TD></TR><TR><TD>172640</TD><TD>BJNIT PWG / Kfqsrxr</TD><TD>$13.188,00</TD><TD>$2.163,48</TD><TD>$2.163,48</TD><TD>100,00%</TD></TR></TBODY></TABLE><P></P><UL><LI>The Sort by variable that I'm using to change the sorting of the table seems to work but I was wondering if there is a way to add the Ascending/Descending bit directly in the variable expression without opening the Properties.</LI></UL><P></P><P>The Opportunity filters work fine.</P><P></P><P>Thanks everyone for your help!</P></BODY></HTML> Sun, 09 Sep 2012 12:01:51 GMT https://community.qlik.com/t5/QlikView/Filter-and-sort-in-pivot-table/m-p/388411#M491133 2012-09-09T12:01:51Z Re: Filter and sort in pivot table https://community.qlik.com/t5/QlikView/Filter-and-sort-in-pivot-table/m-p/388412#M491134 <HTML><HEAD></HEAD><BODY><P>Ideas anyone?</P></BODY></HTML> Mon, 10 Sep 2012 19:04:44 GMT https://community.qlik.com/t5/QlikView/Filter-and-sort-in-pivot-table/m-p/388412#M491134 2012-09-10T19:04:44Z