Create Visual Level Filter to take out "Blank" values which may be empty strings

[Anonymous]

I have a table that one field has a bunch of blank values and I would like to remove those rows. Putting a filter in of "is not blank" makes no difference as I believe these are empty strings, or possibly even a space.

1) How do I create a visual level filter to take out rows with empty strings?

2) When I try to use "is not" and then put in a space, when I click apply it resets the filter, so how do I create a visual level filter to remove rows where a field is just a space?

Thanks

[amitchandak · Accepted solution]

It might be a zero-length string.

Create a new column like this

new column=

Switch( true(),

isblank([column]) , "NA"

[column]="","NA",

[column])

And filter on NA

[Anonymous]

---

@amitchandak wrote:

It might be a zero-length string.

Create a new column like this

new column=

Switch( true(),

isblank([column]) , "NA"

[column]="","NA",

[column])

And filter on NA

---

This works and is how I will do it for now (I am just using isBlank instead of NA as NA could be an actual value inserted). Just a note, you missed a comma after isblank([column]) , "NA"

It is a pity though that this can't be done at a visual filter level thought, would be way quicker. Maybe they could add an empty string or no value field to the is and is not to give that filter a little more depth?

[Greg_Deckler]

Should be able to just use basic filtering and uncheck the boxes for the blank/blanks?

[Anonymous]

---

@Greg_Deckler wrote:

Should be able to just use basic filtering and uncheck the boxes for the blank/blanks?

---

No, this will not work as it is filtering on what is needed and whats not needed. By selecting everything except for whats not needed, when the data is refreshed, if any new values come through (and this is invoice number, so that will happen), it won't select them and your results will not include anything new.