topic Re: Pick match function is not working in App Development

Pick match function is not working

RanOuerg — Wed, 10 Jan 2024 14:31:27 GMT

Hello all,

Due to performance issues, I aimed to replace the nested if with Pick and Match, but encountered problems. I used the following formula in a column's background color: pick(match(($(variable) > 10000), true()), red(), green()). However, this approach didn't work as expected. When I tried using an if statement instead, I obtained the correct results. Any insights into what might be causing the issue?"

Thank you in advance.

Re: Pick match function is not working

Anil_Babu_Samineni — Wed, 10 Jan 2024 14:49:42 GMT

@RanOuerg Not sure the use of True() here. perhaps this?

pick(match(($(variable)) > 10000)+1, green(), red())

Re: Pick match function is not working

RanOuerg — Wed, 10 Jan 2024 15:12:03 GMT

i remplaced true() with 1 but it still not working

Re: Pick match function is not working

rwunderlich — Wed, 10 Jan 2024 16:00:54 GMT

Pick(Match()) will generally perform no faster or slower than an if(). If the if() function works for you, I would go with that. If this is causing you performance issues, the issue is likely in the $(variable) expression.

-Rob

Re: Pick match function is not working

RanOuerg — Thu, 11 Jan 2024 08:29:40 GMT

Understand, but why it not working ? what is the issue with my formula

Re: Pick match function is not working

marcus_sommer — Thu, 11 Jan 2024 09:03:16 GMT

Your match() could result in two values - 0 for a non-matching and 1 if the variable-comparing returned true(). The 0 couldn't be fetched from pick() because their index starts with 1. To comprehend it I suggest to split it into several parts, like:

$(variable)
$(variable) > 10000
match(($(variable) > 10000), true())

beside each other.

Re: Pick match function is not working

RanOuerg — Thu, 11 Jan 2024 14:39:11 GMT

i don't see how can i split my formula, i don't really understand your solution.

Thank you for adding more details please?

Re: Pick match function is not working

marcus_sommer — Fri, 12 Jan 2024 08:56:29 GMT

Just use each part as an own expression within a table-chart. Each nested expression is resolved starting from the most inner expression-part and then next wrapping one takes the result as parameter and performed the own calculation with it.

The aim by separating all expression-parts is to comprehend the single results and their evolution within the expression-chain to detect logically issues which will occur if the results are unexpected in any way.