Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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
Partner

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

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

View solution in original post

2 Replies
alexandros17
Partner
Partner

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

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

View solution in original post

samvile18
Creator III
Creator III
Author

Lovely job, thanks very much.