Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Where

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

Try

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

View solution in original post

5 Replies
Anonymous
Not applicable

Try

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

vinieme12
Champion III
Champion III

TRY

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
smilingjohn
Specialist
Specialist
Author

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  .

tresesco
MVP
MVP

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
Champion III
Champion III

smilingjohn‌ have you tried the above?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.