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);
} );
