Qlik Community

Qlik Sense App Development

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

ptl14495
New Contributor

Null Results in a Dimension - Selectable and Nameable

Hi, Good Afternoon

When building a dimension, i would like that the null results could have one name of my choice, and that these Null results could be selected.

the tests i made didn't work well but here is what i have tried,

If ( IsNull ( [Campo1]),'Sem informação', [Campo1] )

Thank you

Fernando Rodrigues

4 Replies
MVP
MVP

Re: Null Results in a Dimension - Selectable and Nameable

Why don't you perform this in the script?

If(IsNull([Campo1]), 'Sem informação', [Campo1]) as [Campo1]

ptl14495
New Contributor

Re: Null Results in a Dimension - Selectable and Nameable

Hello Sunny,

thank you for your fast response.

I am not confortable in doing this in the scrit.

I am doing this as a Dimension. Is it possible?

thank you

Kind Regards

Fernando Rodrigues

MVP
MVP

Re: Null Results in a Dimension - Selectable and Nameable

>>and that these Null results could be selected.

If you don't do something like Sunny suggested (or NullasValue) in script, you will not be able to select the nulls, regardless of the how you calculate the dimension. Selections on a calculated dimensions are always applied to the underlying fields and you cannot select the nulls in the underlying.

ptl14495
New Contributor

Re: Null Results in a Dimension - Selectable and Nameable

OK.

Thank you both for your help.

Kind regards

Community Browser