How to use wildmatch function in set analysis

[pra_kale]

Hi,

In my data i am having Remark column which contains Failure is written as Failure and failure both ways and basis of that i am giving policy count.

How I can do this in set analysis using wildmatch function.

Thanks in advance.

[maxgro]

you can use a ? or a *

only({$ <Remark={"failur?"}>} Remark)

replace only with your aggr function

e.g.

load * inline [

Remark

failure

Failure

OK

ok

ko

KO

fail

FAIL

FAILURE

];

[pra_kale]

Thanks Maxgro for your help..

But when i am tried at my end i unable to place this into my expression. Can you please help where i should put into my expression. Below is the my expression

if(channel = 'Total'),Num((count({<Remark={'Failure'}>} Total DISTINCT Policynumber) / count(Total DISTINCT Policynumber) * 100),00.00), Num((count({<Remark={'Failure'}>} DISTINCT Policynumber) / count( DISTINCT Policynumber) * 100),00.00))

Thanks in Advance.

[marcus_sommer · Accepted solution]

Try it in the way maxgro has suggested:

if(channel = 'Total'),

Num((count({<Remark={"failur?"}>} Total DISTINCT Policynumber) /

count(Total DISTINCT Policynumber) * 100),00.00),

Num((count({<Remark={"failur?"}>} DISTINCT Policynumber) /

count( DISTINCT Policynumber) * 100),00.00))

- Marcus

[pra_kale]

Thanks all for your help...It works.

I have used Num((count({<Remark={"failur*"}>}