Solved: Re: Null Dimensions - Qlik Community

mrainey18 · ‎2017-12-20

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?

OmarBenSalem · ‎2017-12-20

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

do as follow as a dimension;

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

View solution in original post

agigliotti · ‎2017-12-20

could you post a screenshot?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

OmarBenSalem · ‎2017-12-20

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

do as follow as a dimension;

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