Hypercube not updated after selection / amount of elements to high

MWerner — Tue, 04 Jul 2023 13:54:04 GMT

Hi!

I want to display a master element metric in a mashup. To do this, I open the application via its ID, set a selection via field API and have the hypercube created.

Nevertheless, the hypercube contains significantly more elements, although only one element was selected by the selection.

Would someone be so kind and give me a hint why the hypercube is not updated to one element?

Many greetings!

Here an example:

/*
 * Basic responsive mashup template
 * @owner Enter you name here (xxx)
 */
/*
 *    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 myCB(reply, app){
 console.log(reply);
// the hypercube has more than one element in its array.
 }
 //open apps -- inserted here --
 var app = qlik.openApp('my-897f-app-a929-id', config);
 var myField = app.field('myUserID').selectValues(['001'], true, true);
 //get objects -- inserted here --

 //create cubes and lists -- inserted here --

 app.createCube({
 "qInitialDataFetch": [
 {
 "qHeight": 20,
 "qWidth": 2
 }

 ],

 "qDimensions": [
 {
 "qDef": {
 "qFieldDefs": [
 "#myDim1"
 ]

 },

 "qNullSuppression": true,

 "qOtherTotalSpec": {

 "qOtherMode": "OTHER_OFF",

 "qSuppressOther": true,

 "qOtherSortMode": "OTHER_SORT_DESCENDING",

 "qOtherCounted": {

 "qv": "5"

 },

 "qOtherLimitMode": "OTHER_GE_LIMIT"
 }
 }
 ],
 "qMeasures": [

 {

 "qLabel": "myMeasure1",

 "qLibraryId": "myMeasure1ID",

 "qSortBy": {
 "qSortByState": 0,
 "qSortByFrequency": 0,
 "qSortByNumeric": 0,
 "qSortByAscii": 1,
 "qSortByLoadOrder": 0,
 "qSortByExpression": 0,
 "qExpression": {
 "qv": " "
 }
 }
 }
 ],
 "qSuppressZero": false,
 "qSuppressMissing": false,
 "qMode": "S",
 "qInterColumnSortOrder": [],
 "qStateName": "$"
 },myCB);
} );

Re: Hypercube not updated after selection / amount of elements to high

Chirantha — Tue, 04 Jul 2023 14:40:59 GMT

Hey! Please refer to this other post where a similar question was asked. Hope it helps

Re: Hypercube not updated after selection / amount of elements to high

MWerner — Tue, 04 Jul 2023 14:54:21 GMT

Thank you for your reply!

But unfortunately the solution from @Øystein_Kolsrud does not help (I also read it.)

I used and call already a callback function and nevertheless there is clearly more than only one array element in the hypercube.

But thank you very much for your reply @Chirantha !

Re: Hypercube not updated after selection / amount of elements to high

alex_colombo — Thu, 06 Jul 2023 13:39:23 GMT

Hi @MWerner could you please post what you are receiving from the hypercube and what are you expecting?

topic Re: Hypercube not updated after selection / amount of elements to high in Integration, Extension & APIs

Hypercube not updated after selection / amount of elements to high

Re: Hypercube not updated after selection / amount of elements to high

Re: Hypercube not updated after selection / amount of elements to high

Re: Hypercube not updated after selection / amount of elements to high