I cannot figure out why my expression is not working

[Tiger1]

I have a table that i need to hide rows based on a column value. I want to hide ALL rows that have the value “Payments” in the “document Type” column - see raw data table:

Here is my expression:

Yet in my app - i still see rows with the column value - “Payments”:

[Aleksi]

What is the column type?

[Tiger1]

Text

[Bahbus]

Out of curiosity, does it correctly filter to only payments if you were to switch from <> to = ? I know this isn’t what you want in the long run, I just want to see if it correctly filters everything else.

[Tiger1]

i can try it - i may be putting the expression in the wrong place…

[Aleksi]

Or any chance that the value contains space in the end?

[Tiger1]

no. These columns shouldn’t carry any spaces:

[Aleksi]

Actually… it’s in a wrong place. You should use slice instead of Show?

[Tiger1]

oh ok… So in the slice - use that expression? Is my expression correct?

[Aleksi]

Yes it is. Create a slice and then use it as a condition rule. Then use that slice as a source for your view.

[Tiger1]

ok. I will try this. Thanks

[Aleksi]

You’re welcome

[Tiger1]

worked! Now i need to also take out “Credit Memos” do i use:

AND(…

or

OR(…

[Bahbus]

In your case, OR().

[Tiger1]

Ok. Thanks again guys…

[Tiger1]

Well…

I am still seeing the “Credit Memos”:

Raw Data Table:

[Bahbus · Accepted solution]

Sorry, I forgot since we are using inequalities, you need to use AND().

[Aleksi]

Have you changed the source for your view? You should use the slice instead of original table.

[Tiger1]

Yes - i changed the source. but i was using OR(…

Let me try AND(…

[Tiger1]

ok… using AND(… worked.

Thank ya’ll very much!