topic Help! How to make sort on an expression in extension in QlikView https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445683#M1162739 <HTML><HEAD></HEAD><BODY><P>I have this Defintion.xml</P><P><SPAN>&lt;ExtensionObject xmlns:xsi="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="SelectionMapCAFireBug" Description="SelectionMapCAFireBug" PageHeight="20"&gt;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Dimension DropTarget="1st Dimension" Initial="=PrescriberId"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Title" value="Map"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.1.0.Definition" value="=Latitude"/&gt; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.2.0.Definition" value="=Longitude"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.3.0.Definition" value="=ZipCode"/&gt; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!-- !IMPORTANT: Set the initial size of the QV map--&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Layout.Normal.Width" Value="500" /&gt;</P><P>&lt;/ExtensionObject&gt;</P><P></P><P>I need to sort &lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&gt; in descending order.</P><P>I saw this post (<A _jive_internal="true" class="loading" href="https://community.qlik.com/message/241769" title="http://community.qlik.com/message/241769">http://community.qlik.com/message/241769</A>) but I need to sort based on expression.</P><P></P><P>Please help!</P><P></P><P>Thank you very much.</P></BODY></HTML> Tue, 18 Dec 2012 01:08:16 GMT 2012-12-18T01:08:16Z Help! How to make sort on an expression in extension https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445683#M1162739 <HTML><HEAD></HEAD><BODY><P>I have this Defintion.xml</P><P><SPAN>&lt;ExtensionObject xmlns:xsi="</SPAN><A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="SelectionMapCAFireBug" Description="SelectionMapCAFireBug" PageHeight="20"&gt;</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Dimension DropTarget="1st Dimension" Initial="=PrescriberId"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Measurement DropTarget="Measure" Initial="" /&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Title" value="Map"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.1.0.Definition" value="=Latitude"/&gt; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.2.0.Definition" value="=Longitude"/&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Chart.Expression.3.0.Definition" value="=ZipCode"/&gt; </P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!-- !IMPORTANT: Set the initial size of the QV map--&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;Initiate Name="Layout.Normal.Width" Value="500" /&gt;</P><P>&lt;/ExtensionObject&gt;</P><P></P><P>I need to sort &lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&gt; in descending order.</P><P>I saw this post (<A _jive_internal="true" class="loading" href="https://community.qlik.com/message/241769" title="http://community.qlik.com/message/241769">http://community.qlik.com/message/241769</A>) but I need to sort based on expression.</P><P></P><P>Please help!</P><P></P><P>Thank you very much.</P></BODY></HTML> Tue, 18 Dec 2012 01:08:16 GMT https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445683#M1162739 2012-12-18T01:08:16Z Re: Help! How to make sort on an expression in extension https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445684#M1162740 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I'll answer here as well so we can reference it later on.</P><P></P><P>You could add something like the line below to your definition.xml file:</P><P><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #737373; background: white;">&lt;Initiate Name="Chart.Dimension.0.Sort.ByYValue.Use" value="1"/&gt;</SPAN></P><P></P><P>There is a qvprops.htm file that exposes all the different chart properties. I've searched and searched but it seems we have removed it from the SDK so I'll just upload it here instead with reservations that it might be outdated.</P></BODY></HTML> Wed, 19 Dec 2012 08:28:05 GMT https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445684#M1162740 Alexander_Thor 2012-12-19T08:28:05Z Re: Help! How to make sort on an expression in extension https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445685#M1162742 <HTML><HEAD></HEAD><BODY><P>Forward to <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/293114#293114" title="http://community.qlik.com/message/293114#293114">http://community.qlik.com/message/293114#293114</A></P></BODY></HTML> Wed, 19 Dec 2012 16:36:16 GMT https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445685#M1162742 2012-12-19T16:36:16Z