Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AlexBrn
Contributor
Contributor

field getData() 200 rows

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?

Labels (2)
1 Solution

Accepted Solutions
AlexBrn
Contributor
Contributor
Author

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.

View solution in original post

1 Reply
AlexBrn
Contributor
Contributor
Author

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.