Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.