topic Re: If and Match in Script in QlikView

If and Match in Script

psk180590 — Tue, 20 Mar 2018 16:12:40 GMT

Hello All,

I'm looking to have multiple match conditions in my script.

Ex: if(match(FNum,'140','150','160','170') and Match(ANum,'*'),1,0)as Absolut_N

The First Match works fine but, the second with * doesn't work. Please, help me on how to include * in a Match condition.

Regards
Sai.

Re: If and Match in Script

Chanty4u — Tue, 20 Mar 2018 16:18:42 GMT

try like this

If(Match([FNum],'140','150','160','170') and Match([Anum],'*'), 'Fnum', Anum)

Re: If and Match in Script

jwjackso — Tue, 20 Mar 2018 16:21:48 GMT

If(Match(FNum,'140') and Match(ANum,Chr(42)),1,0) as Absolut_N;

Re: If and Match in Script

wdchristensen — Tue, 20 Mar 2018 16:29:11 GMT

Might want to verify that [Anum] is not null. The * matches non-null values.

Re: If and Match in Script

psk180590 — Tue, 20 Mar 2018 16:34:18 GMT

Both the solutions don't work for me. They give 0 as result

Re: If and Match in Script

PrashantSangle — Tue, 20 Mar 2018 16:43:22 GMT

Can you be more specific with Anum with *

what are you trying to do??

can you explain with sample file??

Regards,

Re: If and Match in Script

Peter_Cammaert — Tue, 20 Mar 2018 16:43:29 GMT

First things first: what is it that you want to test? And what does your data look like?

Re: If and Match in Script

jwjackso — Tue, 20 Mar 2018 16:43:59 GMT

What are the possible values for Anum?

Re: If and Match in Script

Chanty4u — Tue, 20 Mar 2018 16:46:25 GMT

may be

if(match(FNum,'140','150','160','170') ,'Yes',if(Match(ANum,'*'),'No','')) as Newfield

Re: If and Match in Script

wdchristensen — Tue, 20 Mar 2018 16:53:29 GMT

If(Match([FNum],'140','150','160','170'), If(Match([Anum],'*', 1, 0)), -1) as Absolut_N

Re: If and Match in Script

psk180590 — Tue, 20 Mar 2018 19:21:19 GMT

Thanks all for the suggestions.

Basically, for the above mentioned FNum there has to be a ANum selected it can be 10,20,30...100.

Here, i'm looking to generate a field where the FNum is as mentioned above and the ANum can be any slected number.

Re: If and Match in Script

Digvijay_Singh — Tue, 20 Mar 2018 21:20:25 GMT

I think you should use wildmatch for wildcards, may be like this -

if(match(FNum,'140','150','160','170') and WildMatch(ANum,'*'),1,0)as Absolut_N

Re: If and Match in Script

psk180590 — Wed, 21 Mar 2018 07:47:26 GMT

The suggestions above work for me, but just a curious question: Can we not use '=' in script as in SetAnalysis

Ex: if(match(FNum,'140','150','160','170') and ANum="*",1,0) as Absolut_N

When i use this is the script, it gives me an Error : Field "*" Not Found.