Access dimensional "Include null values" in hypercube

[jonvitale]

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/...

Anyone know how to access this variable?

[bmd · Accepted solution]

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/NxDime...

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

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

[jonvitale]

Thanks so much Gabriel