topic Re: Load Criteria help required in QlikView

Load Criteria help required

samvile18 — Fri, 14 Jun 2013 15:05:23 GMT

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?

Re: Load Criteria help required

alexandros17 — Fri, 14 Jun 2013 15:15:25 GMT

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

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

Re: Load Criteria help required

samvile18 — Mon, 17 Jun 2013 08:44:45 GMT

Lovely job, thanks very much.