Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yuvi
Contributor
Contributor

Making visible only negative values from a table

I have a table of amounts and I need to filter it so that it only shows credits or negative numbers. When I use a if statement, it nulls or grays out the cells in the "amount" column that is a positive but does not hide the entire row.  I've also tried suppress null values and 0 values option but it doesn't work

I'm trying to use this set expression to create the filter but I'm getting an error: "Error in expression: ')' expected."

if($amount)<0, Sum(amount),0)

 

 

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this

=if(amount < 0, amount)

 

yuvi
Contributor
Contributor
Author

That just grays out the cells containing positive values in that column. I'm still able to see the rows.