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”:
Solved! Go to Solution.
Sorry, I forgot since we are using inequalities, you need to use AND().
What is the column type?
Text
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.
i can try it - i may be putting the expression in the wrong place…
Or any chance that the value contains space in the end?
no. These columns shouldn’t carry any spaces:
Actually… it’s in a wrong place. You should use slice instead of Show?
oh ok… So in the slice - use that expression? Is my expression correct?
Yes it is. Create a slice and then use it as a condition rule. Then use that slice as a source for your view.
ok. I will try this. Thanks
You’re welcome
worked! Now i need to also take out “Credit Memos” do i use:
AND(…
or
OR(…
In your case, OR().
Ok. Thanks again guys…
Well…
I am still seeing the “Credit Memos”:
Raw Data Table:
Sorry, I forgot since we are using inequalities, you need to use AND().
Have you changed the source for your view? You should use the slice instead of original table.
Yes - i changed the source. but i was using OR(…
Let me try AND(…
ok… using AND(… worked.
Thank ya’ll very much!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |