# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Hide a null dimension but keep associated calculated measure.

Hi, I have a dimension that shows up as null but has quota information on it that I need. I want to hide the "-" but keep the 544,023 that shows up at the bottom. The problem I have is that if I click "suppress null values" under Model then the 544,023 is not calculated. How can I keep the amount in the null value but hide the null dimension itself?

 Model Brand Quota CAPITAL PLYO \$0 DEVICE PLYO \$0 DEVICE CYNO 0 OPTIONS PLYO \$0 - CYNO \$544,023 \$544,023

So I want it to look like this:

 Model ]Brand Total Quota CAPITAL PLYO \$0 DEVICE PLYO \$0 DEVICE CYNO \$0 OPTIONS PLYO \$0 \$544,023
1 Solution

Accepted Solutions
Employee

## Re: Hide a null dimension but keep associated calculated measure.

1. Aggr(IF(isnull(Model),'',Model,Model)
2. Aggr(IF(isnull(Model),'',Brand,Model,Brand)
7 Replies
MVP

## Re: Hide a null dimension but keep associated calculated measure.

How to use - Dimensionality()

New Contributor III

## Re: Hide a null dimension but keep associated calculated measure.

I actually am using dimensionality but it does not help with hiding the null value.

MVP

## Re: Hide a null dimension but keep associated calculated measure.

Would you be able to share a sample where you are doing this?

Employee

## Re: Hide a null dimension but keep associated calculated measure.

1. Aggr(IF(isnull(Model),'',Model,Model)
2. Aggr(IF(isnull(Model),'',Brand,Model,Brand)
Esteemed Contributor

## Re: Hide a null dimension but keep associated calculated measure.

Try as dimension:

=if(len(trim(Brand))=0,'',Brand)

result:

New Contributor III

## Re: Hide a null dimension but keep associated calculated measure.

Thank you! a variation of this worked for me.

New Contributor III

## Re: Hide a null dimension but keep associated calculated measure.

Thank you, Omar. The isnull expression above worked for me so I did not test this solution but I greatly appreciate the response!