topic Re: If(Match), If(NotMatch) in QlikView

If(Match), If(NotMatch)

Tue, 22 Nov 2016 06:09:42 GMT

Hi Experts,

I am trying to assign values to a field. Please help me understand if it is possible to do this,

If(Match(Tpcode, '91A', '92A','93B', '94D','95C'), (Tpcode) ,(If there is no match, then assign that value and store it as Tpcode2.

E.g.

Based on the above statement, if there are macthing values in Tpcode 91A and 92A, then Tpcode2 will have those values, Can I do something where Tpcode does not have ,'93B', '94D','95C' and I can assign these values to Tpcode2?

Please help!!!

Re: If(Match), If(NotMatch)

sushil353 — Tue, 22 Nov 2016 06:16:51 GMT

do you want to store this value in a variable?

try this:

pick(Match(Tpcode, '91A', '92A','93B', '94D','95C'),'Tpcode','Tpcode2')

Re: If(Match), If(NotMatch)

tresB — Tue, 22 Nov 2016 06:26:10 GMT

May be like:

If(Match(Tpcode, '91A', '92A','93B', '94D','95C'), Tpcode, Tpcode2) as Tpcode2

Re: If(Match), If(NotMatch)

Tue, 22 Nov 2016 06:27:08 GMT

Thanks for replying Sushil. I am beginner. Can you please show me how to do this?