Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
To extract data from an object you need to know two things:
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: ...
}