Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Access dimensional "Include null values" in hypercube

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?

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Access dimensional "Include null values" in hypercube

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

284412.png

View solution in original post

2 Replies
Highlighted
Employee
Employee

Re: Access dimensional "Include null values" in hypercube

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

284412.png

View solution in original post

Highlighted
Creator III
Creator III

Re: Access dimensional "Include null values" in hypercube

Thanks so much Gabriel