topic Re: How to add dimensions and expressions for an extension object? in QlikView

How to add dimensions and expressions for an extension object?

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

Is it possible to add dimensions and/or expressions for an extension object using JavaScript?

Re: How to add dimensions and expressions for an extension object?

alex_nerush — Tue, 19 Nov 2013 12:28:37 GMT

After couple of hours googling community and digging into the QlikView Ajax library i've found solution and would like to share ideas here.

So, to add dimension and/or expression from Extension's JavaScript code you can write following code:

Qva.AddExtension('MyExtension', function(){

// extension's code is ommited

// to add dimension:

this.Layout.SetProperty("Chart.Dimension.Add", "", false)

this.Layout.SetProperty("Chart.Dimension.0.Field", "MyDimensionField", true);

// to add expression

this.Layout.SetProperty("Chart.Expression.Add", "", false)

this.Layout.SetProperty("Chart.Expression.0.0.Definition", "SUM(MyValueField)", true)

});

But there is a new question: how to determine the number of dimensions and expressions?

Re: How to add dimensions and expressions for an extension object?

Mon, 05 May 2014 12:29:25 GMT

Hi Alex,

do you found a solution of your problem?

I've tried to use your code, it works very well.

Have you tried to remove a dimension or expression?

Have a nice day,

Mattia

Re: How to add dimensions and expressions for an extension object?

alex_nerush — Mon, 05 May 2014 12:51:14 GMT

Hi Mattia, i've tried only to add dimensions and expressions.

Re: How to add dimensions and expressions for an extension object?

Mon, 05 May 2014 13:06:35 GMT

Hi Alex,

thank's for your very fast reply.

Do you think it's possible to remove dimensions/expression like in VbScript?

I've not found any document online that explain well the Javascript code to manage the QlikView Document.

Also your property: this.Layout.SetProperty("Chart.Dimension.Add", "", false)

doesn't return any result in Google or in some QlikView Api.

Where do you find it?

Thank's

Mattia

Re: How to add dimensions and expressions for an extension object?

alex_nerush — Mon, 05 May 2014 13:24:20 GMT

Please, try following:

to delete dimension:

Chart.Dimension.0.Remove

0 - dimension's index, starting from zero.

to delete expression

Chart.Expression.0.Remove

0 - expression's index, starting from zero.

actually, it's not documented featutes.

Re: How to add dimensions and expressions for an extension object?

Mon, 05 May 2014 14:22:19 GMT

Hi Alex,

i've tried to execute this pieces of codes:

_this.Layout.SetProperty("Chart.Dimension.0.Remove", "", false);

_this.Layout.SetProperty("Chart.Expression.0.Remove", "", false);

But nothing happen. No errors, but no Dimensions/Expressions removes.

Why, in your opinion, anybody write a document of the Javascript fetures?

It would be very important have a list of all possible method to call to interact with the QlikView Object.

Mattia

Re: How to add dimensions and expressions for an extension object?

Alexander_Thor — Mon, 05 May 2014 15:01:15 GMT

Keep in mind that once you deploy your document through QVS you can't interact with the object like that.

You can't persist changes back to the core application once it's deployed or create hypercubes at runtime without "shared objects".

Re: How to add dimensions and expressions for an extension object?

Mon, 05 May 2014 15:16:56 GMT

So it's impossible to have a complete conversion from VbScript to Javascript?

I can't read a list box possible values, add/remove dimensions and expressions?

Do you know if it's possible to put a QlikView object (like a pivot chart or bar chart) in my extension?

Thank's

Mattia

Re: How to add dimensions and expressions for an extension object?

Alexander_Thor — Mon, 05 May 2014 15:21:26 GMT

Well, you can't add or remove dimensions with macros in the AJAX client either

Sure you can read list box values.

It might be easier if you try to explain what you are trying to accomplish.

Re: Re: How to add dimensions and expressions for an extension object?

Mon, 05 May 2014 15:41:11 GMT

Why i can't add/remove dimensions/expressions?

With this code, (in my extension) i can do it: (only add, remove function doesn't work)

_this.Layout.SetProperty("Chart.Dimension.Add", "", false)

_this.Layout.SetProperty("Chart.Dimension.1.Field", "my_new_dimension", true);

I put "1" in dimension because i've just one dimension in my table.

This code put a new dimension at the end of my (basic) html table.

With this code, i see the new dimension

// Create a variable to hold generated html

$html += "<table border='1'>";

var $headerRow = $dataSet.HeaderRows[0];

$html += "<tr>";

for (var $i = 0; $i < $headerRow.length; $i++) {

$html += "<th>" + $headerRow[$i].text + "</th>";

}

$html += "</tr>";

// Cycle Through the data

for (var $i = 0; $i < $dataSet.Rows.length; $i++) {

// get the row

var $row = $dataSet.Rows[$i];

// Generate html

$html += "<tr>";

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

$html += "<td>" + $row[$j].text + "</td>";

}

$html += "</tr>";

}

// Finalise the html

$html += "</table>";

Re: How to add dimensions and expressions for an extension object?

Tue, 14 Jul 2015 09:30:36 GMT

Hi ,

Was googling and just came across your post

Basically i am trying to do some dynamic selection from an extension object for applying selection i need to use
_this.Data.SelectTextsInColumn(0, true, "*");

here the _this.Data object refrences the Dimension field so basically i tried you above to dynamically change the field in the javascript here is the code

function getData()

{

var lineDelimiter = '\n';

var tagDelimiter = ':';

var valueDelimiter = ';';

var currentSelectionQv =_this.Layout.Text0.text;

// alert('Value from Expression ' + currentSelectionQv);

var arrSelectionLines = currentSelectionQv.split(lineDelimiter);

if (arrSelectionLines.length > 0 && arrSelectionLines[0] != '-') {

for (i = 0; i < arrSelectionLines.length; i++) {

var line = arrSelectionLines;

var tagPos = line.indexOf(tagDelimiter);

var fieldName = line.substr(0, tagPos);

var fieldValues = line.substr(tagPos + 1, line.length - tagPos).split(valueDelimiter);

alert(fieldName); // Selected Field Name

// to add dimension:

_this.Layout.SetProperty("Chart.Dimension.Add", "", false)

_this.Layout.SetProperty("Chart.Dimension.0.Field", fieldName, true);

alert('Layout Ran !');

alert(fieldValues); //Select Field Value

}

else

{

//Do Nothing

}

I will be basically using arrSelectionLines variable to feed in my Input string containing the Field name and Field value from a Web Service . Now the above code is running in a circular loop any idea why ?

Re: How to add dimensions and expressions for an extension object?

sgrubic — Tue, 27 Sep 2016 14:50:06 GMT

Hello, Mattia,

I know it's been a long time, but only now have I stumbled upon this, searching for the answer to your question:

"how to determine the number of dimensions and expressions?"

With a bit of googling I've found this answer: QlikView Extension determine amount of Dimensions from first data row (if multiple) · GitHub, to quote:

// get amount of Dimensions

var nDimensions = this.Data.Rows[0].filter(function(col){return !(col.color == undefined);}).length;

Apparently, dimensions columns in QV generated data get their own color each, while expressions columns' color is undefined. Definitely a weird way to get to the information as useful and simple as this... but hey.

Hope someone except for me will find this useful. Thank you, ralfbecher of GitHub.

Re: How to add dimensions and expressions for an extension object?

Fri, 19 May 2017 10:51:03 GMT

Hey Tushar,

I know this question is quite old, but did you manage to solve this problem?

I´m currently struggeling with the same situation....

Best regards

Florian

Re: How to add dimensions and expressions for an extension object?

yashpalrawat198 — Mon, 23 Sep 2019 10:31:44 GMT

Did you find solution to add dimension dynamically?

I am trying to add dimension using below code but it is not working

object.Layout.SetProperty("Chart.Dimension.Add", "", false);
object.Layout.SetProperty("Chart.Dimension.0.Field", "MyDimension1", true);

object.Layout.SetProperty("Chart.Dimension.Add", "", false);
object.Layout.SetProperty("Chart.Dimension.1.Field", "MyDimension2", true);