Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Markbhai
Creator
Creator

Hide a row in a straight table

Is it possible to hide a row within a straight table?

I have a High Risk Table which currently shows all items but I want it only to show those which match a risk value.

 

Possible values are High, Low, and N/A

I want to hide all of the N/A ones.

Thanks

Mark.

Labels (1)
1 Solution

Accepted Solutions
rodrigo_martins
Partner - Creator
Partner - Creator

You could try something like that in your first dimension (assuming the field used is Dimension1):

if([Risk value]='N/A', null(), [Dimension1])

And remember to uncheck "Include null values"

View solution in original post

3 Replies
theoat
Partner - Creator III
Partner - Creator III

Can you show us your table ?

rodrigo_martins
Partner - Creator
Partner - Creator

You could try something like that in your first dimension (assuming the field used is Dimension1):

if([Risk value]='N/A', null(), [Dimension1])

And remember to uncheck "Include null values"

Markbhai
Creator
Creator
Author

My final expression was:

 

=IF([DPIA Status] <> 'N/A', [DPIA Status])

This rmoved the whole row once the 'Include Null Values' was un checked.

Thanks

Mark