QLIK Sense .NET API : trying to get measure/ dimension for all objects

mel78 — Mon, 08 Jul 2019 20:26:36 GMT

I read the QLIK Sense for .NET API. I am able to get data (measure / dimension) for most of the objects except TreeMap, Map, Distribution plot and Boxplot.

I used genericObject.GetHyperCubePivotDatafor Pivot, List object for Filterpane and for others, I used genericObject.GetHyperCubeData.

What should I do for TreeMap, Map, Distribution plot and Boxplot? I am unable to get the measures and dimensions for these objects?

Re: QLIK Sense .NET API : trying to get measure/ dimension for all objects

Øystein_Kolsrud — Mon, 29 Jul 2019 08:44:11 GMT

To extract data from an object you need to know two things:

Where in the properties structure are the hypercubes located.
What modes do the hypercubes have.

For 1) you can do the following:

var allCubePaths = o.GetAllHyperCubePagers().Select(p => p.Path);

For 2) you'll need to inspect the "Mode"property of the cube and then use the "GetHypercubeData" version corresponding to that mode. Something like this:

var cubeMode = o.Properties.CloneSubstructureAs<HyperCubeDef>(cubePath).Mode; switch (cubeMode) { case NxHypercubeMode.DATA_MODE_PIVOT: ... case NxHypercubeMode.DATA_MODE_PIVOT_STACK: ... case NxHypercubeMode.DATA_MODE_STRAIGHT: ... case NxHypercubeMode.DATA_MODE_TREE: ... }

topic Re: QLIK Sense .NET API : trying to get measure/ dimension for all objects in Integration, Extension & APIs

QLIK Sense .NET API : trying to get measure/ dimension for all objects

Re: QLIK Sense .NET API : trying to get measure/ dimension for all objects