Show Only Relevant Rows in QlikSense - Dimensions

[Inna_Shnaiderman]

Hi,

I am new to QlikSense.

I have  a table- attached which consists only of dimensions. I need to make condition that the rows will show up only when the dimension is_exception=1.

Please help me how to code this condition.

[GaryGiles · Accepted solution]

You can use the Aggr() function to a set analysis to a dimension expression to limit the rows that are displayed.  Use the following expression for the is_exception dimension and un-check the "Include null values" option for the dimension.

=aggr(Only({$<is_exception={1}>} is_exception), is_exception) 

[JuanGerardo]

Hi @Inna_Shnaiderman, an easy way to do this could be creating one calculated dimension in your table that shows null when is_exception is not 1, then tell Qlik Sense to not show these nulls:

=If(is_exception = 1, MyDimension)

JG

[Inna_Shnaiderman]

Works!Great!Thanks!