Data slice not working

[SantiagoSalazar]

Hello,

I have a problem when creating a data slice. The condition should return all rows that have the value “MONTERIA” in the Localidad column.  The slice is not returning any rows, also when I hit “test” to test the condition does not show any row. It does not show anyting, nor true or false

Heare a snip of the table and the condition. Any help will be appreciated, I really don’t know what I am doing wrong, the condition used to work fine.ConditionTable

[WillowMobileSys]

First, as you probably know, you only need the part: [Localidad] = "MONTERIA"  and I would use the TRIM(0 function just in case there are spaces.  Like below.

If you still see an issue then the question would be if you have any Security Filters in place that might be filtering out those rows?  Sometime I will temporarily add a Table view to show all the rows in the source table and make sure the rows I expecte to see there are there.

TRIM([Localidad]) = "MONTERIA" 

 I hope this helps!

[SantiagoSalazar]

Thanks for the answer. The trim() tip is really good, sadly it didn´t fixed the problem.

The table view also helped. I realized that I can´t see any data from the original table (view displays “no items”). Also, there is no security filter. I am really confused, when using other tables the slice does work.

[Steve]

---

@SantiagoSalazar wrote:

I realized that I can´t see any data from the original table (view displays “no items”).

---

I'd think that means your app isn't using the worksheet you want. Reconfigure the table.

[SantiagoSalazar · Accepted solution]

Hello Steve, I double checked, it is the right table.  Also I "found" what was wrong, I changed the key column of the table and now the slice does work.