topic Access dimensional "Include null values" in hypercube in Integration, Extension & APIs

Access dimensional "Include null values" in hypercube

jonvitale — Thu, 07 Dec 2017 18:14:53 GMT

Hi,

I am working on a Qlik Sense extension and want to make use of the "Include null values" option that comes out-of-the-box with each dimension. I assumed that I could access this value in the hypercube, but I do not see it. If you take a look at the API documentation for the hypercube, and then open "NxDimensionInfo" there doesn't seem to be anything about "including null values". (Of course, I could totally be missing it.)

http://help.qlik.com/en-US/sense-developer/September2017/Subsystems/EngineAPI/Content/GenericObject/LayoutLevel/Hypercube.htm

Anyone know how to access this variable?

Re: Access dimensional "Include null values" in hypercube

bmd — Tue, 23 Jan 2018 10:47:31 GMT

Let me know if this is what you are looking for…

The `qNullSuppression` property correlates to the ‘Include Null Values’ checkbox being unchecked, otherwise the property will not be defined. The property is documented on the NxDimension object of the HyperCubeDef.

http://help.qlik.com/en-US/sense-developer/September2017/Subsystems/EngineAPI/Content/Structs/NxDimension.htm

http://help.qlik.com/en-US/sense-developer/September2017/Subsystems/EngineAPI/Content/Structs/HyperCubeDef.htm

...model.properties.qHyperCubeDef.qDimensions[<0>].qNullSuppression = true

Re: Access dimensional "Include null values" in hypercube

jonvitale — Tue, 23 Jan 2018 16:32:08 GMT

Thanks so much Gabriel