topic Qlik Sense Pivot-table in Integration, Extension & APIs

Qlik Sense Pivot-table

VGP — Sat, 16 Nov 2024 03:55:48 GMT

Hi All,

In mashup, I want to retrieve pivot table data using qlik sense api. In qlik sense app, pivot table has one dimension and two measures with complex expressions. I have tried using qHyperCubeDef, but it is not fetching data.

Thanks,

Guru

Re: Qlik Sense Pivot-table

ErikWetterberg — Wed, 04 Dec 2019 14:24:09 GMT

Did you remember qInitialDataFetch? Also remember that for a pivot table data is in qPivotDataPages.

Re: Qlik Sense Pivot-table

VGP — Wed, 04 Dec 2019 16:27:48 GMT

Yes ErikWetterberg, I have used qInitialDataFetch property and checked qPivotDataPages also. Below is sample JSON having complex expression, which i am using to get pivot table data . I have logged error in console and error message i am getting as "Object not found". Please tell me whether I am missing any property in qHyperCubeDef. var pvTable = {"qHyperCubeDef":{"qDimensions":[{"qLibraryId":null,"qDef":{"qFieldDefs":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}}],"qMeasures":[{"qLibraryId":null,"qDef":{"qDef":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}},{"qLibraryId":null,"qDef":{"qDef":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}}],"qMode":"P","qIndentMode":true,"qInitialDataFetch":[{"qHeight":2,"qWidth":10}],"qSuppressZero":false,"qSuppressMissing":false,"qNoOfLeftDims":1,"qInterColumnSortOrder":[-1,0],"qStateName":"$"}}; qlik.createGenericObject(pvTable, function(reply){ console.log(reply); }); Thanks, Guru

Re: Qlik Sense Pivot-table

VGP — Wed, 04 Dec 2019 16:59:51 GMT

Yes ErikWetterberg,

I have used qInitialDataFetch property and checked qPivotDataPages also. Below is sample JSON , which i am using to get pivot table data . I have logged error in console and error message i am getting as "Object not found". Please tell me whether I am missing any property in qHyperCubeDef.

var pvTable = {"qHyperCubeDef":{"qDimensions":[{"qLibraryId":null,"qDef":{"qFieldDefs":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}}],"qMeasures":[{"qLibraryId":null,"qDef":{"qDef":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}},{"qLibraryId":null,"qDef":{"qDef":"complex expression"},"qLabel":"complex expression","qSortBy":{"qSortByState":0,"qSortByFrequency":0,"qSortByNumeric":0,"qSortByAscii":1,"qSortByLoadOrder":0,"qSortByExpression":0,"qExpression":{"qv":" "}}}],"qMode":"P","qIndentMode":true,"qInitialDataFetch":[{"qHeight":2,"qWidth":10}],"qSuppressZero":false,"qSuppressMissing":false,"qNoOfLeftDims":1,"qInterColumnSortOrder":[-1,0],"qStateName":"$"}};

qlik.createGenericObject(pvTable, function(reply){
console.log(reply);
});

Thanks,

Guru

Re: Qlik Sense Pivot-table

ErikWetterberg — Wed, 04 Dec 2019 17:35:28 GMT

I avoid using null in my json, try with '' instead.