topic Re: Qlik Sense ApplyPatches API throwing Invalid Parameters in Integration, Extension & APIs

Qlik Sense ApplyPatches API throwing Invalid Parameters

nitinsaivishnu1 — Wed, 08 May 2019 13:41:40 GMT

@dselgo_eidex

@erik_wetterberg

Can you help me on how to replace the dimension/measure of a bar or pie chart using ApplyPatches or SetOptions API..

I used the following mashup from the https://github.com/erikwett/QonnectionsMashupby @erik_wetterberg

but it was throwing me invalid parameters.

The existing dimension is City and i'd like to change it to Country.

Is my qValue correct?

I have the following code

var patches = [{
'qPath': '/qHyperCubeDef/qDimensionInfo/0',
'qOp': 'replace',
'qValue': \"Country\"
}];

vis.applyPatches( patches, false );

Any help would be appreciated.

Re: Qlik Sense ApplyPatches API throwing Invalid Parameters

ErikWetterberg — Wed, 08 May 2019 13:45:13 GMT

Hi,

You're right: your qValue is not correct. It should be a string in a string, so perhaps:

qValue: '"Country"'

or you can use JSON.stringify:

qValue: JSON.stringify('Country')

Re: Qlik Sense ApplyPatches API throwing Invalid Parameters

nitinsaivishnu1 — Wed, 08 May 2019 13:58:48 GMT

Hi Erik,

Thank you for the fast reply.

I tried changing it to both the values you suggested. It still throws me Invalid Parameters

Re: Qlik Sense ApplyPatches API throwing Invalid Parameters

ErikWetterberg — Wed, 08 May 2019 14:05:00 GMT

Hi,

I see now that the path is also wrong, applyPatch patches properties, qDimensionInfo is in the layout, it's called qDimensions in the properties.

https://help.qlik.com/en-US/sense-developer/April2018/APIs/EngineAPI/definitions-HyperCubeDef.html

Re: Qlik Sense ApplyPatches API throwing Invalid Parameters

mek — Wed, 08 May 2019 14:08:23 GMT

Your path isn't quite right: use qDimensions instead of qDimensionInfo.

In addition, the content of qHyperCubeDef/qDimensions/0 is an NxDimension, so replacing that entire struct with a string is not valid, you need to replace the definition of the inline dimension:

{ 'qPath': '/qHyperCubeDef/qDimensions/0/qDef/qFieldDefs/0', 'qOp': 'replace', 'qValue': '"Country"' }

Re: Qlik Sense ApplyPatches API throwing Invalid Parameters

nitinsaivishnu1 — Wed, 08 May 2019 18:43:35 GMT

Hi @mek

Thank you. It worked like a charm 😄

Can you also help me with changing the chart type as well ? Let's say a bar chart to pie chart?

Pardon me for not knowing the qPath correctly.

Will this work?

{
'qPath': '/qInfo/qType',
'qOp': 'replace',
'qValue': '"piechart"'
}