topic Re: Two conditions in one expression in App Development

Two conditions in one expression

Kirsten — Thu, 18 Feb 2021 15:18:51 GMT

I want to have two conditions in one expression, exclude the quarters as well as one value within markets, though below expression returns an error. What is going wrong?

Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'} and {$<[Market]-={'ALL MARKETS'}>} [FirstTimeRight])

This one works

Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}>} [FirstTimeRight])

Re: Two conditions in one expression

marcus_sommer — Thu, 18 Feb 2021 15:28:14 GMT

Change it to:

Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]-={'ALL MARKETS'}>} [FirstTimeRight])

- Marcus

Re: Two conditions in one expression

Kirsten — Thu, 18 Feb 2021 15:31:36 GMT

Ah thanks I see here it doesn't work with an AND statement

Re: Two conditions in one expression

Kirsten — Thu, 18 Feb 2021 15:44:54 GMT

@marcus_sommer what is the expression when you want to select only one item to the list, and not remove the item. E.g. I only want to have a table with North America selected

Re: Two conditions in one expression

marcus_sommer — Thu, 18 Feb 2021 16:24:17 GMT

Not using -= which excludes the listed values else just = maybe so:

Max({$<[Period]-={'2020 Q3','2020 Q2','2020 Q1', '2020 Q4', '2019 Q3', '2019 Q2', '2019 Q1'}, [Market]={'North America'}>} [FirstTimeRight])

- Marcus

Re: Two conditions in one expression

Kirsten — Thu, 18 Feb 2021 16:52:57 GMT

@marcus_sommer yes that works thanks. The solution is very straightforward I was working with a plus (+) sign instead of minus (-) which didn't work