topic Pivot Table Sub Sort in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Sort/m-p/249373#M94766 <HTML><HEAD></HEAD><BODY><P>Hi... </P><P></P><P>I have a pivot table which looks like the following (please excuse the data - this is sample data)....</P><P><IMG alt="Pivot Sort.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/7860_Pivot+Sort.jpg" width="450" /></P><P></P><P>It is currently sorted by the 3rd column (31/07/2004 sales) using the following expression...</P><P></P><P>=sum(IF(dor_OrderDate = varToday), sls_SalesAmount))</P><P></P><P>What I would like to do is first of all sort by the expression above then, for the accounts that do not have sales today, sort by their decending months sales i.e. 6th Column (Jul-2004 Sales).</P><P></P><P>=sum(IF(Month(dor_OrderDate = Month(varToday), sls_SalesAmount))</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Is this possible?</SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Regards</SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Paul</SPAN></P></BODY></HTML> Fri, 14 Oct 2011 10:15:58 GMT pkelly 2011-10-14T10:15:58Z Pivot Table Sub Sort https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Sort/m-p/249373#M94766 <HTML><HEAD></HEAD><BODY><P>Hi... </P><P></P><P>I have a pivot table which looks like the following (please excuse the data - this is sample data)....</P><P><IMG alt="Pivot Sort.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/7860_Pivot+Sort.jpg" width="450" /></P><P></P><P>It is currently sorted by the 3rd column (31/07/2004 sales) using the following expression...</P><P></P><P>=sum(IF(dor_OrderDate = varToday), sls_SalesAmount))</P><P></P><P>What I would like to do is first of all sort by the expression above then, for the accounts that do not have sales today, sort by their decending months sales i.e. 6th Column (Jul-2004 Sales).</P><P></P><P>=sum(IF(Month(dor_OrderDate = Month(varToday), sls_SalesAmount))</P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Is this possible?</SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;"> </SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Regards</SPAN></P><P><SPAN style="color: #333333; font-size: 10pt;">Paul</SPAN></P></BODY></HTML> Fri, 14 Oct 2011 10:15:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Sub-Sort/m-p/249373#M94766 pkelly 2011-10-14T10:15:58Z