topic Re: Where in QlikView

Where

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

Hi All,

Iam using the where clause , can any suggest me if iam wrong . from dept iam trying to take only set and jet

where Dept_S='set' and Dept_S='jet' and not match(User,'A435\devt'):

Thanks

Anonymous — Thu, 24 Nov 2016 10:26:39 GMT

Try

where match(Dept_S,'jet','set') and not match(User,'A435\devt');

vinieme12 — Thu, 24 Nov 2016 10:29:16 GMT

TRY

where MATCH(Dept_S,'set','jet')>0 and match(User,'A435\devt')=0;

smilingjohn — Thu, 24 Nov 2016 10:51:18 GMT

I dont think so the match is required actaully the code was like this

where Dept_S='set' and not match(User,'A435\devt'):

now they want to show jet also , how do i go with this .

tresB — Thu, 24 Nov 2016 10:58:20 GMT

There are various ways you can use like with match() or without match().

You can replace your and with or like:

Dept_S='set' or Dept_S='jet' and not match(User,'A435\devt')

Note, you might have to put an additional brace like

(Dept_S='set' or Dept_S='jet') and not match(User,'A435\devt')

Depending upon your expected output

vinieme12 — Thu, 24 Nov 2016 12:04:20 GMT

smilingjohn‌ have you tried the above?