topic Re: How to use wildmatch function in set analysis in QlikView

How to use wildmatch function in set analysis

pra_kale — Thu, 19 Jan 2017 17:46:18 GMT

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.

Re: How to use wildmatch function in set analysis

maxgro — Thu, 19 Jan 2017 17:55:12 GMT

you can use a ? or a *

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

replace only with your aggr function

e.g.

load * inline [

Remark

failure

Failure

fail

FAIL

FAILURE

];

Re: How to use wildmatch function in set analysis

pra_kale — Mon, 23 Jan 2017 15:56:50 GMT

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.

Re: How to use wildmatch function in set analysis

marcus_sommer — Mon, 23 Jan 2017 16:06:35 GMT

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

Re: How to use wildmatch function in set analysis

pra_kale — Sun, 29 Jan 2017 08:02:37 GMT

Thanks all for your help...It works.

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