Wild Match function in Set Analysis

LP27 — Sat, 16 Nov 2024 19:02:34 GMT

Hi,

I am not sure how to use wild match within set Analysis.

Here is my case -

Now I want to exclude the R values in column Remark. So it should only show row E2;E3;E4 and E4;

Here is what I have tried :-

Count({$<Remark - = {"*R*"}>} OrderNo)

Note sure if I have to use single or double quotes to search the string ?
Since my Remark Column already contains * with values, will it still be considered doing "*R*"

Could some one guide me best way to solve this issue.

Thanks in advance!!!

Re: Wild Match function in Set Analysis

nisha_rai — Wed, 26 Feb 2020 10:55:35 GMT

Hi,

Please use the below condition:

Count(distinct {<Remark-={"*R*"}>}[Order No])

kaushiknsolanki — Wed, 26 Feb 2020 10:57:48 GMT

Hi,

It works in my case.

See the image Below.