topic Sorting in QlikView Extension Objects in QlikView

Sorting in QlikView Extension Objects

Mon, 26 Jan 2026 16:26:21 GMT

Hi,

I've been trying for some time now to sort a column (Dimension data) in an extension object. The option isn't there in the (default) properties unless I change the type to Straight table, but then some functionality is lost in my object which is unacceptable.

The column is the first one as well when loaded. It's numeric data with four digits, 1101, 1102, ... , 1112 for example.. the order right now is based on a different field, and it doesn't matter if you bring it along or not... still the same order...

Is there anything you can write in the Definition.xml or an option in properties (if you write your own)? Has anyone had the same problem?

Thanks,

Albin

Sorting in QlikView Extension Objects

Alexander_Thor — Mon, 24 Oct 2011 18:32:22 GMT

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

Tue, 25 Oct 2011 09:21:39 GMT

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:

Thanks Alexander,

/Albin

Sorting in QlikView Extension Objects

Alexander_Thor — Tue, 25 Oct 2011 15:52:04 GMT

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

Tue, 25 Oct 2011 19:15:29 GMT

I was curious as well, and tried a few times. One option is to list the options as radiobuttons

<tr>

Sorting:

</td>

By A->Z: <input name="ascii" type="radio" avq="edit:.Chart.Dimension.0.Sort.ByAscii.Use" value="0" />

etc...

</td>

</tr>

Haven't tested a lot with other sortings but it's a starting point

Re: Sorting in QlikView Extension Objects

Thu, 26 Jul 2012 03:45:56 GMT

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

Tue, 18 Dec 2012 02:01:58 GMT

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>