topic Re: Load dimensions separately in qMatrix in Integration, Extension & APIs

Load dimensions separately in qMatrix

Anonymous — Tue, 23 Jan 2018 16:37:27 GMT

Hi,

I am working on extension, and I would like to load some data in it.

The Qlik way by adding dimensions is super, and easy to do.

However, there is some problems also.

Let say I need two dimensions inside (that are not related to each other), for example dimension A and B.

Let say dimension A has 200 items, and B has 300 items.

My qMatrix will then have 60.000 rows, (200x300) because they are not related, so it will create n x m matrix out of it.

But I wish to have only 500 rows.

Is there a way, to tell qlik sense application, to give me those dimensions separately and not to make matrix out of it?

Thank you

Marko Zadravec

Re: Load dimensions separately in qMatrix

ErikWetterberg — Wed, 24 Jan 2018 07:56:34 GMT

Hi Marko,

You could use a calculated dimension that concatenates the two dimensions into one. Check this thread for a solution:

Combining values from multiple dimensions in one axis‌

Or you could concatenate in the script and make a new dimension.

Erik Wetterberg

Please mark as Helpful if you find this helps you.

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 08:14:28 GMT

Hi,

Thank you for the answer, but I think this will not help me, because the dimensions are not connected with each other.

Maybe, there is an API, that return filters object (witch are in fact one dimension array). Then I could call this API for A and for B, and then I would convert problem from A x B to A + B... Do you know for any kind of this API?

Re: Load dimensions separately in qMatrix

ErikWetterberg — Wed, 24 Jan 2018 10:09:27 GMT

Well you could use two hyercubes or two listobjects in your extension. In that case you should probably add them to initialProperties. A problem with this is that the standard property panel does not really support multiple hypercubes, so setting it up might be complicated.

Erik Wetterberg

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 10:17:14 GMT

But extensions themselves do support multiple hypercubes.

So in the Properties Panel you just need to allow the names of Dim A & B to be defined. Then in the javascript create 2 hypercubes for the 2 Dim's and concatenate the Dim vales they contain into a single json array

Re: Load dimensions separately in qMatrix

ErikWetterberg — Wed, 24 Jan 2018 12:17:55 GMT

Yes, that's possible, but then you can't configure other properties for the hypercubes, you might have problems with using Sense Dimensions and/or fields, which the standard property panel solves for you.

Not really knowing the use case,a solution might be to use a standard hypercube for one dimension, and a text field for the other.

Erik Wetterberg

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 12:38:46 GMT

Yup - You are correct it all depends on the what if's and the precise use case.

It may be that defining a new field of [Dim A+B] in the qvf load script could be the best way to go.

But as you say, whilst not really knowing the use case it is hard to say.

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 12:45:47 GMT

Just had a thought... if it is super easy to do it in QlikView then maybe posting a sample qvw with it working could help understanding.

I no longer use View so with only the unlicensed Personal Edition of View I would not be able to open it, but I expect others would have a licenced QlikView.

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 14:51:26 GMT

Thank you for your discussion.

I understand that it all depend on case.

I just need the names of dimensions items, so I can build json file to POST a REST api.

The two hyperCube would be super, but I don't know how to call (get dimension) inside JS.

Could you post some example how to get the dimensions Items from name inside JS.

Marko Zadravec

Re: Load dimensions separately in qMatrix

ErikWetterberg — Wed, 24 Jan 2018 15:35:06 GMT

Hi,

Concat(distinct FieldName) will give you all values in a field. Might be useful with a delimiter also.

Erik Wetterberg

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 16:58:41 GMT

Is this inside QS application or in java script?

I meant if you have any tutorials how to load specific dimensions items by name of the dimension inside java script.

Something like getDimension or getVariableById but that works

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 17:25:37 GMT

In javascript :

Try a couple of CallBack's something like this

function getDimAData(reply, app) {

/* Add code here to populate a json array with DimA values */

}

});

}

function getDimBData(reply, app) {

/* Add code here add the DimB values onto your json array */

}

});

}

That respectively call createList to create their cubes

app.createList({

qDef: {qFieldDefs: ["DimA"]}, qFrequencyMode: "V", qInitialDataFetch: [{qHeight: 1000,qWidth: 1}]

}, getDimAData);

app.createList({

qDef: {qFieldDefs: ["DimB"]}, qFrequencyMode: "V", qInitialDataFetch: [{qHeight: 1000,qWidth: 1}]

}, getDimBData);

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 17:37:21 GMT

Yes, that was what I want. Could I ask you what is qFrequencyMode: "V"? and qFieldDefs: ["DimB"] is a name of DimB or id of DimB? Did I need to add DimA and DimB as dimensions in Qlik Sense Applications to this extension widgets?

Thank you a lot.

Re: Load dimensions separately in qMatrix

Anonymous — Wed, 24 Jan 2018 17:54:38 GMT

If you Google qlik sense createList this is the second hit

createList method ‒ Qlik Sense Developers

Here it gives an example and link to ListObjectDef ‒ Qlik Sense Developers

How you need to exploit the createList method will depend on your precise needs.

[You'll get loads of other hits as well]

Re: Load dimensions separately in qMatrix

ErikWetterberg — Fri, 26 Jan 2018 14:18:26 GMT

Hi,

If you want to use this in an extension you need to put it in a qStringExpression. In an extension it would be something like this:

initialProperties:{
  fieldA:{
        qStringExpression: "=Concat(FieldA, ';')"
 },
  fieldB: {
        qStringExpression: "=Concat(FieldB, ';')"
 }
},
paint:function($element,layout){
//layout.fieldA will contain all values for fieldA,
//layout.fieldB will contain all values for fieldB

Second parameter is the delimiter, I've used ;, you should be able to use just about anything.

Not clear if you want the result to depend on the users selections or not, you might need to add some set analysis to avoid having your result change when the user makes selections.

You don't need to loop through the values and you don't need to handle the asynchronity problems, the framework will do that for you. If you want the extension to be snapshottable and printable, thats possible (might be irrelevant).

I haven't actually tested this code, so there might be syntax errors.

Hope this helps

Erik Wetterberg