<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Help! How to make sort on an expression in extension in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445619#M1238934</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Alex:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Very appreciate your reply.&lt;/P&gt;&lt;P&gt;I tried this suggetion in extension, it doesn't work. Here is my Definition.xml&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;lt;ExtensionObject xmlns:xsi="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance"&gt;http://www.w3.org/2001/XMLSchema-instance&lt;/A&gt;&lt;SPAN&gt;" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="Top N - 2" Description="Top N Selection - 2" PageHeight="20"&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Dimension DropTarget="1st Dimension" Initial=""/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Sum(Vials):" Initial="=Sum(Vials)" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Latitude" Initial="=Latitude" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Longitude" Initial="=Longitude" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="ZipCode" Initial="=ZipCode" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Title" value="Map"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!-- !IMPORTANT: Set the initial size of the QV map--&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Layout.Normal.Width" Value="500" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;STRONG&gt;&amp;lt;Initiate Name="Chart.Dimension.0.Sort.ByYValue.Use" value="1"/&amp;gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;/ExtensionObject&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But I think this idea should be right becase 'sort by Y value' is working in a standard chart object.&lt;/P&gt;&lt;P&gt;Here is what I tested: I put this 'sort by Y value' in a standard chart with&amp;nbsp; Dimension = Id, Expression = Sum(***) and a couple of other columns, and then set 'sort by Y value - descending' on Dimension id, the bar chart looks right to me, the id is sorted by descending order of Sum(***).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is it because some syntax error in my definition.xml causes not working in extension?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 19 Dec 2012 16:16:55 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-12-19T16:16:55Z</dc:date>
    <item>
      <title>Help! How to make sort on an expression in extension</title>
      <link>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445617#M1238931</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am having this Definition.xml&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;lt;ExtensionObject xmlns:xsi="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" target="_blank"&gt;http://www.w3.org/2001/XMLSchema-instance&lt;/A&gt;&lt;SPAN&gt;" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="SelectionMapCAFireBug" Description="SelectionMapCAFireBug" PageHeight="20"&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Dimension DropTarget="1st Dimension" Initial="=PrescriberId"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement DropTarget="Measure" Initial="" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement DropTarget="Measure" Initial="" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement DropTarget="Measure" Initial="" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement DropTarget="Measure" Initial="" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Title" value="Map"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Expression.1.0.Definition" value="=Latitude"/&amp;gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Expression.2.0.Definition" value="=Longitude"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Expression.3.0.Definition" value="=ZipCode"/&amp;gt; &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!-- !IMPORTANT: Set the initial size of the QV map--&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Layout.Normal.Width" Value="500" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;/ExtensionObject&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I would to sort by descending order on&amp;nbsp;&amp;nbsp; &amp;lt;Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I saw this post(&lt;A _jive_internal="true" class="loading" href="https://community.qlik.com/message/241769" title="http://community.qlik.com/message/241769" target="_blank"&gt;http://community.qlik.com/message/241769&lt;/A&gt;) which is making a sort on dimension, but in my case, I need to have it in my expression.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please help!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 16:26:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445617#M1238931</guid>
      <dc:creator />
      <dc:date>2026-01-26T16:26:21Z</dc:date>
    </item>
    <item>
      <title>Re: Help! How to make sort on an expression in extension</title>
      <link>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445618#M1238933</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hey,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'll answer here as well so we can reference it later on.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;You could add something like the line below to your definition.xml file:&lt;/P&gt;&lt;P&gt;&lt;SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Arial','sans-serif'; color: #737373; background: white;"&gt;&amp;lt;Initiate Name="Chart.Dimension.0.Sort.ByYValue.Use" value="1"/&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Dec 2012 08:27:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445618#M1238933</guid>
      <dc:creator>Alexander_Thor</dc:creator>
      <dc:date>2012-12-19T08:27:38Z</dc:date>
    </item>
    <item>
      <title>Re: Help! How to make sort on an expression in extension</title>
      <link>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445619#M1238934</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Alex:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Very appreciate your reply.&lt;/P&gt;&lt;P&gt;I tried this suggetion in extension, it doesn't work. Here is my Definition.xml&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;&amp;lt;ExtensionObject xmlns:xsi="&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance"&gt;http://www.w3.org/2001/XMLSchema-instance&lt;/A&gt;&lt;SPAN&gt;" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="Top N - 2" Description="Top N Selection - 2" PageHeight="20"&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Dimension DropTarget="1st Dimension" Initial=""/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Sum(Vials):" Initial="=Sum(Vials)" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Latitude" Initial="=Latitude" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="Longitude" Initial="=Longitude" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Measurement Label="ZipCode" Initial="=ZipCode" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Chart.Title" value="Map"/&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;!-- !IMPORTANT: Set the initial size of the QV map--&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;Initiate Name="Layout.Normal.Width" Value="500" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;STRONG&gt;&amp;lt;Initiate Name="Chart.Dimension.0.Sort.ByYValue.Use" value="1"/&amp;gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;/ExtensionObject&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But I think this idea should be right becase 'sort by Y value' is working in a standard chart object.&lt;/P&gt;&lt;P&gt;Here is what I tested: I put this 'sort by Y value' in a standard chart with&amp;nbsp; Dimension = Id, Expression = Sum(***) and a couple of other columns, and then set 'sort by Y value - descending' on Dimension id, the bar chart looks right to me, the id is sorted by descending order of Sum(***).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is it because some syntax error in my definition.xml causes not working in extension?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you very much!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 19 Dec 2012 16:16:55 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-How-to-make-sort-on-an-expression-in-extension/m-p/445619#M1238934</guid>
      <dc:creator />
      <dc:date>2012-12-19T16:16:55Z</dc:date>
    </item>
  </channel>
</rss>

