Dimensionlimitation in MashUp Tables?

iskeam — Mon, 10 Oct 2022 13:55:40 GMT

Hi,

I want to create a table using a mashup hypercube.

Which seems to work to a certain degree.

When I create my hypercube array it seems to work fine up to a width (number of rows) of 5.

I console.logged the mashup function and I get an array in the log, for the hypercube function if I have a dimension of 5 and lower. If I try to increase this, no array is a result in the console.log, although the dimension seems to be all right.

Subsequently, If I undo to out-comment of the other rows of my table, nothing gets visualized.

Is there a limitation of dimensions, or did I miss something else?

I am glad for any feedback!

BR, max

please find below my code:

/*
* Basic responsive mashup template
* @owner Enter you name here (itMRu)
*/
/*
* Fill in host and port for Qlik engine
*/
var prefix = window.location.pathname.substr( 0, window.location.pathname.toLowerCase().lastIndexOf( "/extensions" ) + 1 );
var config = {
host: window.location.hostname,
prefix: prefix,
port: window.location.port,
isSecure: window.location.protocol === "https:"
};
require.config( {
baseUrl: ( config.isSecure ? "https://" : "http://" ) + config.host + (config.port ? ":" + config.port : "") + config.prefix + "resources"
} );

require( ["js/qlik"], function ( qlik ) {
qlik.on( "error", function ( error ) {
$( '#popupText' ).append( error.message + "<br>" );
$( '#popup' ).fadeIn( 1000 );
} );
$( "#closePopup" ).click( function () {
$( '#popup' ).hide();
} );

//callbacks -- inserted here --
function customTable(reply, app){
console.log(reply)
$("#customTable").empty();
$.each(reply.qHyperCube.qDataPages[0].qMatrix,function(k,val){
//console.log(val[0].qText,val[1].qText,val[8].qText)
var html='<tr><th>Datum</th><td>'+val[1].qText+'</td></tr>'
+'<tr><th>Gruppe</th><td>'+val[0].qText+'</td></tr>'
+'<tr><th>Patient</th><td>'+val[2].qText+'</td></tr>'
+'<tr><th>Abteilung</th><td>'+val[3].qText+'</td>'+'<th>Eingriff</th><td>'+val[4].qText+'</td></tr>'
//+'<th>ANÄ-Art</th><td>'+val[5].qText+'</td></tr>'
+'<tr><td colspan=5>-</td></tr>'
//+'<td>'+val[5].qText+'</td>'
//+'<td>'+val[6].qText+'</td>'
//+'<td>'+val[7].qText+'</td>'
//+'<td>'+val[8].qText+'</td></tr>'
$("#customTable").append(html);
console.log('Länge='+val.length);
});
}
//open apps -- inserted here --
var app = qlik.openApp('30f3e9da-6e63-4ec4-a5f8-85ebab527f0b', config);

//get objects -- inserted here --
app.getObject('QV01','mjyWcd');
app.getObject('QV02','LPVPHm');
//create cubes and lists -- inserted here --
app.createCube({
"qInitialDataFetch": [
{
"qHeight": 2000,
"qWidth": 5
}
],
"qDimensions": [
{
"qDef": {
"qFieldDefs": [
"OPGruppe"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"geplantesOPDatum"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"Patient"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"Abteilung"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"Eingriff"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"ASA"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"ASA"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"Freigabestatus"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
},
{
"qDef": {
"qFieldDefs": [
"Operakommentar"
]
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qSuppressOther": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qOtherCounted": {
"qv": "5"
},
"qOtherLimitMode": "OTHER_GE_LIMIT"
}
}
],
"qMeasures": [
{
"qDef": {
"qDef": "id"
},
"qLabel": "id",
"qLibraryId": null,
"qSortBy": {
"qSortByState": 0,
"qSortByFrequency": 0,
"qSortByNumeric": 0,
"qSortByAscii": 1,
"qSortByLoadOrder": 0,
"qSortByExpression": 0,
"qExpression": {
"qv": " "
}
}
}
],
"qSuppressZero": false,
"qSuppressMissing": false,
"qMode": "S",
"qInterColumnSortOrder": [],
"qStateName": "$"
},customTable);
} );

Re: Dimensionlimitation in MashUp Tables?

iskeam — Mon, 10 Oct 2022 14:39:40 GMT

Nvm, I did change the rows in"qHeight" to 200 and now the arrays, rows, table is being presented as intended

topic Dimensionlimitation in MashUp Tables? in App Development

Dimensionlimitation in MashUp Tables?

Re: Dimensionlimitation in MashUp Tables?