Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
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?

 

ModelBrandQuota
CAPITALPLYO$0
DEVICEPLYO$0
DEVICECYNO0
OPTIONSPLYO$0
-CYNO$544,023
$544,023

So I want it to look like this:

 

Model

]BrandTotal Quota
CAPITALPLYO$0
DEVICEPLYO$0
DEVICECYNO$0
OPTIONSPLYO$0
$544,023
1 Solution

Accepted Solutions
Employee
Employee

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

Please try using calculated dimensions

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

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

May be dimensionality() function can help you do that

How to use - Dimensionality()

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

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

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

Employee
Employee

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

Please try using calculated dimensions

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

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

Try as dimension:

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

result:

Capture.PNG

danielco223
New Contributor III

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

Thank you! a variation of this worked for me.

danielco223
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!

Community Browser