topic What should be in load script to write multiple condition ? in QlikView

What should be in load script to write multiple condition ?

prahlad_infy — Wed, 25 Nov 2020 16:16:04 GMT

Hello Sirs ,

How to compose this in load script ?

Field1 = abc And Field2 = 123 ,Field3 = 12a AND Field4 not be having a , c OR k then ' 1ST Attempt' as Field_New

Field1 = abc And Field2 = 123 ,Field3 not equals to 12a AND Field4 not be having a , c, k but Field4 has b , q then ' 2ndttempt' as Field_New

Thank you all in advance !!

sunny_talwar — Fri, 03 Aug 2018 14:05:24 GMT

May be this

If(Field1 = 'abc' and Field2 = 123 and Field3 = '12a' and not Match(Field4, 'a', 'c', 'k'), '1st Attempt',

If(Field1 = 'abc' and Field2 = 123 and Field3 <> '12a' and not Match(Field4, 'a', 'c', 'k'), '2nd Attempt')) as Field_new

prahlad_infy — Fri, 03 Aug 2018 14:08:32 GMT

Thank you Sir ,

how to set this part

Field1 = abc And Field2 = 123 ,Field3 not equals to 12a AND Field4 not be having a , c, k but

Field4 has b , q then ' 2ndttempt' as Field_New

sunny_talwar — Fri, 03 Aug 2018 14:10:34 GMT

My bad, may be this

If(Field1 = 'abc' and Field2 = 123 and Field3 = '12a' and not Match(Field4, 'a', 'c', 'k'), '1st Attempt',

If(Field1 = 'abc' and Field2 = 123 and Field3 <> '12a' and Match(Field4, 'b', 'q'), '2nd Attempt')) as Field_new

If Field4 is b and q... then it will def not be a, c, k.. so you don't really need not Match(Field4, 'a', 'c', 'k')

prahlad_infy — Fri, 03 Aug 2018 15:20:59 GMT

Thank you Sir