Expression looking at a slicer

AppSheet AppSheet Q&A
1

Hi,

Is it possible to build an expression that is looking at a slicer?

e.g. I have a list of income for all time and from here I have used slicers to create 2022, 2023, etc.

Within a different table, I want to create a virtual express that only looks at the 2022 slicer.

Currently, I’ve created an expression that looks up the main table and uses Filter, however, I have a feeling that this is not the most efficient way to build.

Thanks for your help.

Gavin

2

Just replace the table name in your expression with the slice name.

2 Likes
3

Slices are treated like tables in AppSheet’s expressions.

1 Like