Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Load Criteria help required

Afternoon all,

I need to reduce some records being returned from an access table, I'm going to do it based on the following criteria...I just can't get the syntaz quite right:

UNITCD = 'STAKEHOLD'

UNITCD = 'NGS'

QUEUECD <> 'END'

STATCD <> 'COMPLETED'

How do I ensure that these are all being met in the where clause?

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

(UNITCD = 'STAKEHOLD' or UNITCD = 'NGS')

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

(UNITCD = 'STAKEHOLD' or UNITCD = 'NGS')

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

samvile18
Creator III
Creator III
Author

Lovely job, thanks very much.