topic Re: API .Net : Get measure and dimension for autochart in sheet in Integration, Extension & APIs

API .Net : Get measure and dimension for autochart in sheet

gwendolineMeta — Mon, 05 Aug 2024 13:49:11 GMT

hi,

In my second shheet, I added a simple measure and simple dimension

How can I get this measure and dimension ?

I try with the public examples (https://github.com/AptkQlik/PublicExamples) but there are no case for "auto-chart"

Is it possible to get the linked fields?

For the first sheet I call app.GetMeasureList() to get the measure but for the measure in the second sheet it's doesn't work

Thank

Gwendoline

Re: API .Net : Get measure and dimension for autochart in sheet

rwunderlich — Mon, 05 Aug 2024 18:28:09 GMT

For the auto-chart the Properties.HyperCubeDef contains the measures, just like a barchart. If you want to use the example code just duplicate the barchart line for auto-chart.

-Rob

Re: API .Net : Get measure and dimension for autochart in sheet

gwendolineMeta — Tue, 06 Aug 2024 08:05:09 GMT

I don't found the class to cast for auto-chart (for Barchart, a class exist)

I try with visualizationBase but Properties.HyperCubeDef doesn't exist.

My object (genericObject) doesn't contain Properties.HyperCubeDef.

NB: I used the last version QlikSense.NetSDK 16.8.0

Re: API .Net : Get measure and dimension for autochart in sheet

Øystein_Kolsrud — Mon, 12 Aug 2024 13:30:40 GMT

You don't really need those client classes to access that info. You can rely on the "AbstractStructure" class to get you the information you need. I have an example focusing on hypercube usage here that might be of use to you:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/tree/master/HypercubeUsage

In particular, have a look at this line which reads a segment of "GenericObjectProperties" and interprets it as being of type "HyperCubeDef":

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/blob/master/HypercubeUsage/Program.cs#L77

Once you've done that, you can access the structure as an instance of the "HyperCubeDef" class.

All those classes from the Client namespace are there primarily to provide a typed layer for accessing entities in the client objects. That part is only partially part of the official API though, so it's not been maintained for quite a while as there is no formal spec available for the different properties of those client object. But the "HyperCubeDef" class is defined based on the engine API, so there is a formal definition available here:

https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/EngineJSONAPI/Content/models-hypercubedef.htm

Re: API .Net : Get measure and dimension for autochart in sheet

gwendolineMeta — Mon, 12 Aug 2024 15:39:34 GMT

it's work fine for me

Thank you