topic Where Clause in QlikView

Where Clause

Anonymous — Wed, 16 Mar 2016 12:26:16 GMT

Hi Guys

I am trying to do a where clause with the following

where client_group_id <> '78' or '7' and statement_ref <> '512'

It is not working any ideas what i am doing wrong?

Thanks

Chanty4u — Wed, 16 Mar 2016 12:30:11 GMT

where ur using this?

and what error ur getting?

and did u chkd with the case field names? upper or lower?

Digvijay_Singh — Wed, 16 Mar 2016 12:30:22 GMT

Not sure but see this works -

where (client_group_id <> '78' or '7') and (statement_ref <> '512')

sunny_talwar — Wed, 16 Mar 2016 12:31:12 GMT

May be this:

Where not Match(client_group_id, 78, 7) and statement_ref <> 512;

sunny_talwar — Wed, 16 Mar 2016 12:32:08 GMT

Digvijay‌ this probably won't work because if you use or, you need to add client_group_id the second time

where (client_group_id <> '78' or client_group_id <> '7') and (statement_ref <> '512');

Digvijay_Singh — Wed, 16 Mar 2016 12:32:25 GMT

where (client_group_id <> '78' or client_group_id <> '7') and (statement_ref <> '512')

See if first OR needs to be AND in case

Digvijay_Singh — Wed, 16 Mar 2016 12:33:05 GMT

Ya, realized just after posting

Anonymous — Wed, 16 Mar 2016 12:37:25 GMT

Thanks Sunny

Tried the others but this managed to work for me

Thanks again!

Anonymous — Wed, 16 Mar 2016 12:37:52 GMT

Digvijay Thanks for help!