Virtual column or dereference in a slice row filter condition

[Ratatosk]

Is it impossible to have a dereference in a slice, or use a virtual column in slice? I’m trying to filter the virtual column “Ansvar” OR alternatively tried the dereference [ID].[Ansvar] but none worked.

||||

[WillowMobileSys]

Yes you can use Virtual Columns and dereferences in a slice. Something else must be wrong.

Ratatosk:

but none worked.

What’s not working?

If it appears that you are not getting any rows returned, have you tried clicking the “View Data” button at the top of the slice to confirm?

[Ratatosk]

Hi WillowMobileSystems,

The problem is that I get all rows returned. It does not filter.

[Kunal_Jain]

Please check if the view is referring to the correct slice in the UX section.

[Ratatosk]

oh dear… it was not the correct slice… Sorry guys.

And thank you for the help

[WillowMobileSys]

Ratatosk:

The problem is that I get all rows returned.

So, if you click on the “View Data” button on the slice, it is showing all the rows?

For a few rows in the slice results, I would trace your ID column back to the referenced table and just confirm the value of the [Ansvar] column.

[Ratatosk · Accepted solution]

oh dear… it was not the correct slice… Sorry guys.

And thank you for the help