topic set analysis with expression searches in App Development

set analysis with expression searches

stefano_marson — Sat, 28 Jan 2023 16:40:43 GMT

Hello everybody,

I would like to write an expression that counts customers who placed orders worth more than 150 in a certain time frame.

I wrote this expression but it is wrong because the symbol " is repeated several times:

Sum({$< customer_id={"=Sum({$<OrderDate={">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>} Amount)>150"} >} oneCustomer)

What is the correct syntax to get the desired result?

Thanks in advance

Re: set analysis with expression searches

ckarras22 — Sat, 28 Jan 2023 19:22:57 GMT

Hello Stefano

You can escape the quotes by preceding with another qoute (below in red)

Sum({$< customer_id={"=Sum({$<OrderDate={"">=$(=Date(vStartDate))<=$(=Date(vEndDate))""}>} Amount)>150"} >} oneCustomer)

Christos K.

Re: set analysis with expression searches

marcus_sommer — Mon, 30 Jan 2023 09:13:44 GMT

It's not a real set analysis else an if-loop and therefore it's better to apply a classical syntax instead of including it with a nested logic into the set analysis. This means something like this:

if(Sum({$<OrderDate={">=$(=Date(vStartDate))<=$(=Date(vEndDate))"}>} Amount)>150,
Sum(oneCustomer))

Re: set analysis with expression searches

stefano_marson — Tue, 31 Jan 2023 10:14:41 GMT

Thank you Christos , your reply is correct!