Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor II

Include NULL values in expression

Hello everyone,

I have the following (simplified) data model, where the blanks in DimB are NULL values :

The business requirement is to display the following chart with :

    - Dimensions :

        - DimA (lines)

        - DimB (columns)

    - Measures :

        - Result (sum of Ind where DimB isn't null)

        - TotalResult (sum of Ind whether DimB is null or not)

I am having a hard time calculating TotalResult, because I need to include NULL values without displaying an extra column for DimB (which was what I obtained when replacing NULL values with a blank in the script, and the users won't accept it).

I would be grateful for any help you could provide, please don't hesitate to ask for more details if my example isn't explicit enough.

Best regards,


2 Replies

Re: Include NULL values in expression

How do we know which null is associated with which value of DimB? Do they always load together (just like in your example)?

New Contributor II

Re: Include NULL values in expression

Hello Sunny,

You're right the example is wrong, I'm going to correct it.

Community Browser