topic Variable number of Dimensions and Measures in an extension in QlikView

Variable number of Dimensions and Measures in an extension

ErikWetterberg — Mon, 26 Jan 2026 16:26:21 GMT

With QlikView 11 SR1 we have added improved support for extensions with a variable number of Dimensions and Measures in your extension. If you want the user to be able to add Dimensions and Measures to your extension you use the Multiple attribute of Dimension and Measure tag.

This might look something like this:

As a result you will get something like this property dialog:

The user will then be able to add Dimensions and Measures with the plus button, remove them with the minus, and edit the definition. You don't have to use both: if you want your extension to support a variable number of Dimensions but only one Measure, you put the attribute just on the Dimension tag.

Your javascript code must of course take into account that you do not now how many columns you have. A simplified version:

for (var rowIx = 0; rowIx < this.Data.Rows.length; rowIx++) {

var row = this.Data.Rows[rowIx];

html += '<tr>';

for (var colIx =0; colIx < row.length; colIx++){

html += '<td>'+row[colIx].text+'</td>';

}

html += '</tr>';

}

I've attached a very small example of this.

In QlikView 11 SR1 you also get improved possibilities to set up the ordering of dimensions. If the user clicks the cogwheel icon, she will get this dialog:

Hope you find this useful.

Erik

Variable number of Dimensions and Measures in an extension

Tue, 17 Apr 2012 09:11:58 GMT

Is there a way to add, remove and reorder dimensions and expressions ? It would be very handy....

Variable number of Dimensions and Measures in an extension

ErikWetterberg — Tue, 17 Apr 2012 09:57:43 GMT

Yes.

Plus and minus-buttons are used for add and remove. If you press the arrow button on the left you can drag the dimension or measure up and down.

Erik

Re: Variable number of Dimensions and Measures in an extension

Tue, 17 Apr 2012 11:40:34 GMT

Sorry I wanted to ask: "Is there a way to add, remove and reorder dimensions and expressions using the javascript API ?"

I am working on an extension which requires expressions to have a specific format to work properly, and since there is no way to do something like that in the qvpp I hide those settings from the properties page and provide a wizard which sets the expressions using Layout.SetProperty(...). I am looking for a way to set the number of measures from the javascript (right now there are something like 7 measures defined in definition.xml, and I just get the data for the Nth first columns, which is a waste of bandwidth and processing power, but I did not manage to find a clever way to achieve that).

Re: Variable number of Dimensions and Measures in an extension

Sat, 03 Aug 2013 21:51:37 GMT

Hi Erik,

Thanks for sharing the technique on how to add multiple measures in the Qlikview Extension object.

1. Is there a way to change the label of the dimensions / measures when the multiple attribute is added on the Dimension and Measurement tags ?

2. Can we add a More button which shows up a panel and allows us to modify the properties for the added dimensions / expressions ?

Re: Variable number of Dimensions and Measures in an extension

alex_nerush — Tue, 19 Nov 2013 08:07:43 GMT

Hello jgeorge

Did you found a solution regarding adding dimensions and expressions using JavaScript?

Re: Re: Variable number of Dimensions and Measures in an extension

Stefan_Walther — Tue, 19 Nov 2013 16:18:27 GMT

Create a custom qvpp, let's say "MyProperties.qvpp", add the following line in the definition.xml

and then add the following code at the appropriate position in the MyProperties.qvpp file:

<div class="prop-bar-chart-header-clickable" avq="prop_listheader:.Chart.Dimension">Dimensions</div>

</div>

</li>

</ul>

<div class="prop-bar-chart-header-clickable" avq="prop_listheader:.Chart.Expression">Expressions</div>

</div>

</li>

</ul>

</div>

Re: Re: Variable number of Dimensions and Measures in an extension

alex_nerush — Tue, 19 Nov 2013 19:36:40 GMT

Hello Stefan! Thanks for help... but my question was about adding and removing dimensions and expressions using the javascript API (for Extension Object). I've found solution and have shared the idea: http://community.qlik.com/thread/99395 .

There is a new question: how can i determine the number of dimensions and expression from an Extension Object's code (using JavaScript)?

p.s. By the way, you have a great blog!!