Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mrainey18
Contributor

Null Dimensions

I have two tables that when linked together have some data mismatches.  This is fine but I would like to display a default value in the table instead of having a light grey box.

Any ideas on how to do this?

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Null Dimensions

let's sayyour table contains; yourDimension and a measure:

do as follow as a dimension;

if (YourDimension&YourMeasure=YourMeasure,'Default value',YourDimension)

2 Replies
agigliotti
Honored Contributor II

Re: Null Dimensions

could you post a screenshot?

omarbensalem
Esteemed Contributor

Re: Null Dimensions

let's sayyour table contains; yourDimension and a measure:

do as follow as a dimension;

if (YourDimension&YourMeasure=YourMeasure,'Default value',YourDimension)