https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550054#M10075 I tried it. Still receiving the same error. Wed, 27 Feb 2019 18:43:59 GMT dselgo_eidex 2019-02-27T18:43:59Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550020#M10073 <P>Hello, I am having a problem using the Visualization APIs <A href="https://help.qlik.com/en-US/sense-developer/February2019/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/VisualizationAPI/setOptions-method.htm" target="_self">setOptions</A> method for my pivot table. Each time I try, I get the following error message:&nbsp;</P><P><SPAN class="name">error</SPAN><SPAN>:&nbsp;</SPAN><SPAN class="object-value-object value">{code: 8, parameter: "Patch value not on valid JSON format.", message: "Invalid parameters"}</SPAN></P><P>In a nutshell, here is what I am trying to do. I want to be able to change the pivot table's properties based on user input. Specifically, I want to change one of the dimensions to a completely different field. I am using <A href="https://github.com/qlik-demo-team/qdt-components" target="_blank" rel="noopener">qdtComponents</A>&nbsp;to handle the chart's creation and to call setOptions. I think it is important to note that when setOptions is called, the entire properties object is passed as a parameter, so it is effectively patching every property.</P><P>I understand that setOptions is essentially a wrapper for applyPatches, and that the specific error I am receiving is from the applyPatches method.</P><P>The weird thing is, I am able to successfully accomplish the desired behavior on other chart types. For testing, I made a line chart and a bar chart with the same measures and there is no problem. When setOptions is called, the chart updates with the correct dimension. The error is only happening for the pivot table.</P><P>Below is the stringified applyPatches call:</P><PRE>{ "delta": true, "handle": 8, "method": "ApplyPatches", "params": [ [ { "qPath": "/qInfo/qId", "qOp": "add", "qValue": "null" }, { "qPath": "/qInfo/qType", "qOp": "add", "qValue": "\"pivot-table\"" }, { "qPath": "/qExtendsId", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qStateName", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qStateName", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qDimensions", "qOp": "add", "qValue": "[{\"qLibraryId\":\"\",\"qDef\":{\"qGrouping\":\"N\",\"qFieldDefs\":[\"STUDENT.YEAR\"],\"qFieldLabels\":[\"Year\"],\"qSortCriterias\":[{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":1,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0}],\"qNumberPresentations\":[],\"qReverseSort\":false,\"qActiveField\":0,\"qLabelExpression\":\"\",\"autoSort\":false,\"cId\":\"bMyJmm\",\"othersLabel\":\"Others\"},\"qNullSuppression\":true,\"qIncludeElemValue\":false,\"qOtherTotalSpec\":{\"qOtherMode\":\"OTHER_OFF\",\"qOtherCounted\":{\"qv\":\"10\"},\"qOtherLimit\":{\"qv\":\"0\"},\"qOtherLimitMode\":\"OTHER_GE_LIMIT\",\"qSuppressOther\":false,\"qForceBadValueKeeping\":true,\"qApplyEvenWhenPossiblyWrongResult\":true,\"qGlobalOtherGrouping\":false,\"qOtherCollapseInnerDimensions\":false,\"qOtherSortMode\":\"OTHER_SORT_DESCENDING\",\"qTotalMode\":\"TOTAL_OFF\",\"qReferencedExpression\":{\"qv\":\"\"}},\"qShowTotal\":false,\"qShowAll\":false,\"qOtherLabel\":{\"qv\":\"Others\"},\"qTotalLabel\":{\"qv\":\"Totals\"},\"qCalcCond\":{\"qv\":\"\"},\"qAttributeExpressions\":[],\"qAttributeDimensions\":[],\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qGrouping\":\"N\",\"qFieldDefs\":[\"STUDENT.BUILDING_NAME\"],\"qFieldLabels\":[\"Building\"],\"qSortCriterias\":[{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":1,\"qSortByAscii\":1,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0}],\"qNumberPresentations\":[],\"qReverseSort\":false,\"qActiveField\":0,\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"cFRFyMf\",\"othersLabel\":\"Others\"},\"qNullSuppression\":true,\"qIncludeElemValue\":false,\"qOtherTotalSpec\":{\"qOtherMode\":\"OTHER_OFF\",\"qOtherCounted\":{\"qv\":\"10\"},\"qOtherLimit\":{\"qv\":\"0\"},\"qOtherLimitMode\":\"OTHER_GE_LIMIT\",\"qSuppressOther\":false,\"qForceBadValueKeeping\":true,\"qApplyEvenWhenPossiblyWrongResult\":true,\"qGlobalOtherGrouping\":false,\"qOtherCollapseInnerDimensions\":false,\"qOtherSortMode\":\"OTHER_SORT_DESCENDING\",\"qTotalMode\":\"TOTAL_OFF\",\"qReferencedExpression\":{\"qv\":\"\"}},\"qShowTotal\":false,\"qShowAll\":false,\"qOtherLabel\":{\"qv\":\"Others\"},\"qTotalLabel\":{\"qv\":\"Totals\"},\"qCalcCond\":{\"qv\":\"\"},\"qAttributeExpressions\":[],\"qAttributeDimensions\":[],\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}}]" }, { "qPath": "/qHyperCubeDef/qMeasures", "qOp": "add", "qValue": "[{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Met\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL_MET_FLAG = {1}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL_MET_FLAG -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"LUFKvh\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false,\"id\":\"cellBackgroundColor\"},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false,\"id\":\"cellForegroundColor\"}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Not Met\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL_MET_FLAG = {0}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL_MET_FLAG -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"TdWtBs\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Not Proficient\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL = {2}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"jrgwPN\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Partially Proficient\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL = {3}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"nfRShs\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Proficient\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL = {4}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"AjvzmM\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}},{\"qLibraryId\":\"\",\"qDef\":{\"qLabel\":\"Advanced\",\"qDescription\":\"\",\"qTags\":[],\"qGrouping\":\"N\",\"qDef\":\"\\n =count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL = {5}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n ) / \\n count({$&lt;\\n ASSESSMENT_LINK.TEST_NAME = {'MSTEP'},\\n ASSESSMENT_RESULTS.PERFORMANCE_LEVEL -= {''}\\n &gt;} DISTINCT ASSESSMENT_RESULT_YEAR_HKEY\\n )\\n \",\"qNumFormat\":{\"qType\":\"F\",\"qnDec\":2,\"qUseThou\":0,\"qFmt\":\"0.0%\",\"qDec\":\".\",\"qThou\":\",\"},\"qRelative\":false,\"qBrutalSum\":false,\"qAggrFunc\":\"\",\"qAccumulate\":0,\"qReverseSort\":false,\"qActiveExpression\":0,\"qExpressions\":[],\"qLabelExpression\":\"\",\"autoSort\":true,\"cId\":\"fkXEQK\",\"numFormatFromTemplate\":true,\"isCustomFormatted\":false},\"qSortBy\":{\"qSortByState\":0,\"qSortByFrequency\":0,\"qSortByNumeric\":-1,\"qSortByAscii\":0,\"qSortByLoadOrder\":1,\"qSortByExpression\":0,\"qExpression\":{\"qv\":\"\"},\"qSortByGreyness\":0},\"qAttributeExpressions\":[{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false},{\"qExpression\":\"\",\"qLibraryId\":\"\",\"qAttribute\":false}],\"qAttributeDimensions\":[],\"qCalcCond\":{\"qv\":\"\"},\"qCalcCondition\":{\"qCond\":{\"qv\":\"\"},\"qMsg\":{\"qv\":\"\"}}}]" }, { "qPath": "/qHyperCubeDef/qInterColumnSortOrder", "qOp": "add", "qValue": "[0,1,-1]" }, { "qPath": "/qHyperCubeDef/qSuppressZero", "qOp": "add", "qValue": "true" }, { "qPath": "/qHyperCubeDef/qSuppressMissing", "qOp": "add", "qValue": "true" }, { "qPath": "/qHyperCubeDef/qInitialDataFetch", "qOp": "add", "qValue": "[{\"qLeft\":0,\"qTop\":0,\"qWidth\":50,\"qHeight\":50}]" }, { "qPath": "/qHyperCubeDef/qReductionMode", "qOp": "add", "qValue": "\"N\"" }, { "qPath": "/qHyperCubeDef/qMode", "qOp": "add", "qValue": "\"P\"" }, { "qPath": "/qHyperCubeDef/qPseudoDimPos", "qOp": "add", "qValue": "-1" }, { "qPath": "/qHyperCubeDef/qNoOfLeftDims", "qOp": "add", "qValue": "2" }, { "qPath": "/qHyperCubeDef/qAlwaysFullyExpanded", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qMaxStackedCells", "qOp": "add", "qValue": "5000" }, { "qPath": "/qHyperCubeDef/qPopulateMissing", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qShowTotalsAbove", "qOp": "add", "qValue": "true" }, { "qPath": "/qHyperCubeDef/qIndentMode", "qOp": "add", "qValue": "true" }, { "qPath": "/qHyperCubeDef/qCalcCond/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qSortbyYValue", "qOp": "add", "qValue": "0" }, { "qPath": "/qHyperCubeDef/qTitle/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qCalcCondition/qCond/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qCalcCondition/qMsg/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qColumnOrder", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/columnWidths", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qStateName", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qDimensions", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qMeasures", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qInterColumnSortOrder", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qSuppressZero", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qSuppressMissing", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qInitialDataFetch", "qOp": "add", "qValue": "[]" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qReductionMode", "qOp": "add", "qValue": "\"N\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qMode", "qOp": "add", "qValue": "\"S\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qPseudoDimPos", "qOp": "add", "qValue": "-1" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qNoOfLeftDims", "qOp": "add", "qValue": "-1" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qAlwaysFullyExpanded", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qMaxStackedCells", "qOp": "add", "qValue": "5000" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qPopulateMissing", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qShowTotalsAbove", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qIndentMode", "qOp": "add", "qValue": "false" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qCalcCond/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qSortbyYValue", "qOp": "add", "qValue": "0" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qTitle/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qCalcCondition/qCond/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qCalcCondition/qMsg/qv", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/qHyperCubeDef/qLayoutExclude/qHyperCubeDef/qColumnOrder", "qOp": "add", "qValue": "[]" }, { "qPath": "/showTitles", "qOp": "add", "qValue": "true" }, { "qPath": "/title", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/subtitle", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/footnote", "qOp": "add", "qValue": "\"\"" }, { "qPath": "/showDetails", "qOp": "add", "qValue": "false" }, { "qPath": "/visualization", "qOp": "add", "qValue": "\"pivot-table\"" } ], true ], "id": 20, "jsonrpc": "2.0" }</PRE><P>And this is the response:</P><PRE>{ "jsonrpc": "2.0", "id": 20, "error": { "code": 8, "parameter": "Patch value not on valid JSON format.", "message": "Invalid parameters" } }</PRE><P>Any help would be greatly appreciated&nbsp;<IMG id="smileyvery-happy" class="emoticon emoticon-smileyvery-happy" src="https://10.236.58.52/i/smilies/16x16_smiley-very-happy.png" alt="Smiley Very Happy" title="Smiley Very Happy" /></P> Sat, 16 Nov 2024 21:19:57 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550020#M10073 dselgo_eidex 2024-11-16T21:19:57Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550028#M10074 <P>Try removing the very first valde, /qInfo/qId. You shouldn’t patch the qId.</P> Wed, 27 Feb 2019 17:42:31 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550028#M10074 ErikWetterberg 2019-02-27T17:42:31Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550054#M10075 I tried it. Still receiving the same error. Wed, 27 Feb 2019 18:43:59 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550054#M10075 dselgo_eidex 2019-02-27T18:43:59Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550239#M10079 <P>Well, then there is something else in your patch array that is wrong. Perhaps you should try just patching the stuff you actually wannt to change, like dimensions? Or at least skip the qLayoutExclude stuff, that's just a way for the client to save stuff when you convert visualizations.</P> Thu, 28 Feb 2019 06:43:52 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550239#M10079 ErikWetterberg 2019-02-28T06:43:52Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550673#M10090 <P>Got it! It looks like the qLayoutExclude was the problem. Once I removed that from the def it began working like a charm. The only reason that I had that in my chart properties was because it was what I got from the developer menu in the app.</P><P>&nbsp;</P><P>Thank you so much Erik, I've been trying to figure this out for the past few days.</P> Thu, 28 Feb 2019 17:44:12 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1550673#M10090 dselgo_eidex 2019-02-28T17:44:12Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1577942#M10488 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/1222">@dselgo_eidex</a>&nbsp;</P><P><SPAN class=""><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6966">@ErikWetterberg</a>&nbsp;</SPAN></P><P><SPAN class="">Can you help me on how to replace the dimension/measure of a bar or pie chart using ApplyPatches or SetOptions API..</SPAN></P><P><SPAN class="">I used the following mashup from the&nbsp; <A href="https://github.com/erikwett/QonnectionsMashup" target="_blank" rel="noopener">https://github.com/erikwett/QonnectionsMashup</A> by&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/6966">@ErikWetterberg</a>&nbsp;</SPAN></P><P><SPAN class="">&nbsp;</SPAN><SPAN class="">but it was throwing me invalid parameters.</SPAN></P><P><SPAN class="">The existing dimension is City and i'd like to change it to Country.</SPAN></P><P><SPAN class="">Is my qValue correct?</SPAN></P><P><SPAN class="">I have the following code</SPAN></P><P>&nbsp;</P><P><SPAN class="">var patches = [{<BR />'qPath': '/qHyperCubeDef/qDimensionInfo/0',<BR />'qOp': 'replace',<BR />'qValue': \"Country\"<BR />}];<BR /><BR /><BR />vis.applyPatches( patches, false );</SPAN></P><P>&nbsp;</P><P><SPAN class="">Any help would be appreciated.</SPAN></P> Wed, 08 May 2019 12:59:02 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1577942#M10488 nitinsaivishnu1 2019-05-08T12:59:02Z https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1577952#M10489 <P>Please don't post new questions on old threads.</P> Wed, 08 May 2019 13:14:33 GMT https://community.qlik.com/t5/Integration-Extension-APIs/setOptions-not-working-for-pivot-table/m-p/1577952#M10489 ErikWetterberg 2019-05-08T13:14:33Z