topic Re: Where statement in Scripting in QlikView

Where statement in Scripting

markgraham123 — Sun, 05 Jul 2015 19:19:06 GMT

Hello Everyone,

I'm trying to fetch the required records using where condition in the script.

Please lemme know whether the syntax i'm using is accurate or not.

Where Name='A' and (Zone='1' or Zone='2' or Zone='3' or Zone='9') and Name='B' and (Zone='12' or Zone='24' or Zone='37');

Please help.

Anonymous — Sun, 05 Jul 2015 19:25:06 GMT

That looks as if it will never return anything as Name will never equal 'A' and equal 'B'.

A complete guess here as to what your requirements are but this would probably return some rows :

Where

( Name='A' and (Zone='1' or Zone='2' or Zone='3' or Zone='9') )

( Name='B' and (Zone='12' or Zone='24' or Zone='37') );

markgraham123 — Sun, 05 Jul 2015 19:32:03 GMT

Hi Bill,

There were many Zone values under Names A and B

I wanna return values only Zone = 1,2,3,9 from A

and

Zone = 12, 24, 37 from B.

Its working...:)

Can i use the same logic for multiple parameters like Name C, D. ..etc..?

markgraham123 — Sun, 05 Jul 2015 19:37:04 GMT

Hi BIll,

Can i use Zone='1*' to fetch all the zonez starting with 1????

Anonymous — Sun, 05 Jul 2015 19:38:07 GMT

It could look neater with the Match() function :

Where

( Name='A' and Match ( 'Zone' ,'1' , '2' , 3' , '9') )

( Name='B' and Match ( 'Zone' , '2' , '24' , '37') ) ;

... and yup, you should be add same logic for your other Name values.

[Editted as I did a typo]

Peter_Cammaert — Sun, 05 Jul 2015 19:41:34 GMT

Still another typo: no quotes around the field name... I won't tell anyone however

Peter_Cammaert — Sun, 05 Jul 2015 19:45:52 GMT

Use Wildmatch(Zone, '1*') instead of Match(Zone, '1') if you want to play with wildcards in Bill's example above. See QV Desktop help for more info.

markgraham123 — Sun, 05 Jul 2015 19:49:46 GMT

Hi Peter,

Thanq Verymuch.