Exclude Data

[Dave_Willett]

Hi Guys.
I have a slice which returns a [TransportType] which the data returned would contain the following values.

COLLECTION
DELIVERY
MAKE AVAILABLE

In the slice, how do I exclude MAKE AVAILABLE ?

In my world of Access Queries it would be something like NotIn(“MAKE AVAILABLE”) so what would be the syntax in the slice and where would I put this in the editor?

Kind Regards

[Steve]

Hmmm… I don’t understand your use of the terms “slice” and “return”. I would have to guess that you want to create a slice that includes only rows with a TransportType column value that is not MAKE AVAILABLE. To do so, use the following as the slice’s row filter expression:

("MAKE AVAILABLE" <> [TransportType])

[Dave_Willett]

Steve:

("MAKE AVAILABLE" <> [TransportType])

Can this be extended Steve.

("MAKE AVAILABLE" ,"COLLECTION",<> [TransportType])

Multiple parameters as above?

[Steve]

It certainly could! Try and figure it out and let us know what you find.

help.appsheet.com

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.

[Dave_Willett]

OR([JobStatus] = “AUTHORISED”, [JobStatus] = “COMPLETE”,[JobStatus] = “ESTIMATED”,[JobStatus] = “AUTH-REQUEST”,[JobStatus] = “APPOINTMENT”,[JobStatus] = “NOTIFICATION”,[JobStatus] = “IN-PROGRESS”)

Thanks Steve, this seems to give me the filtered data I need ( Based on a different dataset but its correct)

Kind Regards

[MultiTech]

how about…

in([JobStatus], list(“AUTHORISED”, “COMPLETE”, “ESTIMATED”, “AUTH-REQUEST”, “APPOINTMENT”, “NOTIFICATION”, “IN-PROGRESS”))

Whenever I get a list of options this big, I typically start thinking backwards - what statuses do I NOT want - that might be a shorter list.

[Dave_Willett]

Good shout… Thnks for your version.

Kind Regards

[MultiTech]

Dave_Willett:

NotIn(“MAKE AVAILABLE”)

Not(in(“Make Available”, [TransportType]))

[Dave_Willett]

Cheers Guys