Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm fairly new to QlikSense, and I have a problem loading data from Hypercubes.
I need to retrieve all the rows from a hypercube, and the methode I use is
var fieldData = app.field( someField ).getData();
fieldData.OnData.bind(function() {
$.each(this.rows, function(key, fieldValue) {
fieldValue.doSomething()
}
}
The fieldData contains around 900 rows, but the getData only loads 200.
I tried setting a parameter like this: getData(1000); but it still loads 200 rows.
My cube is this:
app.createCube({
"qInitialDataFetch": [
{
"qHeight": 1000,
"qWidth": 8
}
],
"qDimensions": 'array of 8 elements',
"qMeasures": [],
"qSuppressZero": false,
"qSuppressMissing": false,
"qMode": "S",
"qInterColumnSortOrder": [],
"qStateName": "$"
},manageVariablesMenu);
I need to use a cube because the dimensions are other fields I need to build the mashup.
What am I doing wrong?
SOLVED!
Found the solution:
Calling the function
app.field( someField ).getData();
needs the argument to be declared as an object as following.
var rowsToLoad = {rows: 1000};
app.field( someField ).getData(rowsToLoad);
This way, the OnData() function retrieves the 1000 rows requested.
SOLVED!
Found the solution:
Calling the function
app.field( someField ).getData();
needs the argument to be declared as an object as following.
var rowsToLoad = {rows: 1000};
app.field( someField ).getData(rowsToLoad);
This way, the OnData() function retrieves the 1000 rows requested.