-
Sorting in QlikView Extension Objects
Alexander Karlsson Oct 24, 2011 2:32 PM (in response to Albin Carnstam )Hey Albin,
You could add this to your script.js,
this.Layout.SetProperty('Chart.Dimension.0.Sort.ByFrequency.Use', '1', true);
For different sorting options check out qvprops.htm in the SDK where you will find all the extension properties.
Cheers,
Alex
-
Sorting in QlikView Extension Objects
Albin Carnstam Oct 25, 2011 5:21 AM (in response to Alexander Karlsson )Hi,
The Sort.ByFrequency didn't work as I wanted it to, but I checked out the qvprops.htm (that I've somehow missed in the SDK, but is of great use) and found Sort.ByNumeric that is what I wanted.
I put the sort setting in the Definition.xml instead to separate the content from the settings:
<Initiate Name="Chart.Dimension.0.Sort.ByNumeric.Use" value="1"/>
Thanks Alexander,
/Albin
-
Sorting in QlikView Extension Objects
Alexander Karlsson Oct 25, 2011 11:52 AM (in response to Albin Carnstam )Ah yes the ByFrequency was just an example
I'm still struggling myself to get that damn setting into the properties.qvpp so the user can choose for themself.
-
Re: Sorting in QlikView Extension Objects
Albin Carnstam Oct 25, 2011 3:15 PM (in response to Alexander Karlsson )I was curious as well, and tried a few times. One option is to list the options as radiobuttons
<tr>
<td colspan="3" class="ToolProperty-Literal">
Sorting:
</td>
<td colspan="2">
By A->Z: <input name="ascii" type="radio" avq="edit:.Chart.Dimension.0.Sort.ByAscii.Use" value="0" />
<input name="ascii" type="radio" avq="edit:.Chart.Dimension.0.Sort.ByAscii.Use" value="1" /><br/>
etc...
</td>
</tr>
Haven't tested a lot with other sortings but it's a starting point
-
Re: Sorting in QlikView Extension Objects
Kokpeng Low Jul 25, 2012 11:45 PM (in response to Albin Carnstam )Hi All,
May i know how we can get the values we can use for Initiate component in the xml file?
Is it possible to use sort by expression?
Many thanks!
-
-
-
-
-
Re: Sorting in QlikView Extension Objects
dabaipang Dec 17, 2012 9:01 PM (in response to Albin Carnstam )I used <Initiate Name="Chart.Dimension.0.Sort.ByNumeric.Use" value="1"/>, but it is not working.
Any ideas?
Here is my Definition.xml
<ExtensionObject xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Definition.xsd" Label="SelectionMapCAFireBug" Description="SelectionMapCAFireBug" PageHeight="20">
<Dimension DropTarget="1st Dimension" Initial="=PrescriberId"/>
<Measurement DropTarget="Measure" Initial="" />
<Measurement DropTarget="Measure" Initial="" />
<Measurement DropTarget="Measure" Initial="" />
<Measurement DropTarget="Measure" Initial="" />
<Initiate Name="Chart.Title" value="Map"/>
<Initiate Name="Chart.Expression.0.0.Definition" value="=Sum(Vials)"/>
<Initiate Name="Chart.Expression.1.0.Definition" value="=Latitude"/>
<Initiate Name="Chart.Expression.2.0.Definition" value="=Longitude"/>
<Initiate Name="Chart.Expression.3.0.Definition" value="=ZipCode"/>
<!-- !IMPORTANT: Set the initial size of the QV map-->
<Initiate Name="Layout.Normal.Width" Value="500" />
<Initiate Name="Chart.Dimension.0.Sort.ByNumeric.Use" value="0"/>
</ExtensionObject>