Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Inna_Shnaiderman
Contributor III
Contributor III

Show Only Relevant Rows in QlikSense - Dimensions

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.

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

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) 

 

 

View solution in original post

3 Replies
GaryGiles
Specialist
Specialist

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) 

 

 

View solution in original post

JuanGerardo
Partner
Partner

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)

JuanGerardo_0-1619348766895.png

 

JG

 

Inna_Shnaiderman
Contributor III
Contributor III
Author

Works!Great!Thanks!