topic Qlik Sense Server - HyperCube with more than one measure in Integration, Extension & APIs

Qlik Sense Server - HyperCube with more than one measure

Wed, 11 Nov 2015 06:35:13 GMT

Hi all,

Newbie at creating hypercubes and am getting stuck on creating one with more than one measure. The code below creates the hypercube with the dimension Phase and the measure SUM([lesserThenTen]) but is missing the second measure.

Any help would be greatly appreciated.

Cheers,

Joel

app1.createCube({

"qDimensions": [{

"qDef": {

"qFieldDefs": ["Phase"]

}

}],

"qMeasures": [{

"qDef": {

"qDef": "SUM([lesserThenTen])",

"qLabel": ""

"qDef1": {

"qDef1": "SUM([greaterThanTen])",

"qLabel": ""

}

}],

"qInitialDataFetch": [{

"qHeight": 20,

"qWidth": 3

}]

}, function(reply){

console.log(reply);

var valueArray = [];

});

Re: Qlik Sense Server - HyperCube with more than one measure

reddy-s — Thu, 12 Nov 2015 16:06:46 GMT

Hi Joel Lau,

Try some thing like this.


	function stock(reply, app){}


	var app = qlik.openApp('7220b23e-c3d7-478c-b977-01285707b21d', config);


app.createCube({
"qInitialDataFetch": [
	{
		"qHeight": 50,
		"qWidth": 3
	}
],
"qDimensions": [
	{
		"qLabel": "Department",
		"qLibraryId": "4150c5a4-e82d-4180-9b8b-93c73c5fb29f",
		"qNullSuppression": true,
		"qOtherTotalSpec": {
			"qOtherMode": "OTHER_OFF",
		"qSuppressOther": true,
			"qOtherSortMode": "OTHER_SORT_DESCENDING",
			"qOtherCounted": {
				"qv": "5"
			},
			"qOtherLimitMode": "OTHER_GE_LIMIT"
		}
	}
],
"qMeasures": [
	{
		"qDef": {
			"qDef": "sum([Stock Value])"
		},
		"qLabel": "sum([Stock Value])",
		"qLibraryId": null,
		"qSortBy": {
			"qSortByState": 0,
			"qSortByFrequency": 0,
			"qSortByNumeric": 0,
			"qSortByAscii": 1,
			"qSortByLoadOrder": 0,
			"qSortByExpression": 0,
			"qExpression": {
			"qv": " "
			}
		}
	},
	{
		"qDef": {
			"qDef": "count([Stock Value])"
		},
		"qLabel": "count([Stock Value])",
		"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": "$"

},function(reply){

console.log(reply);

},stock);

Once you create a hypercube like this it should log the reply in the console like this:

Thanks,

Sangram Reddy.

Re: Qlik Sense Server - HyperCube with more than one measure

Mon, 16 Nov 2015 06:07:29 GMT

Hi Sangram,

My original code was just actually missing some brackets . But thank you for the detailed explanation and sample code. It will be definitely be useful for reference in the future.

Thanks,

Joel