topic Re: Where clause not working (Resident Load) in QlikView

Where clause not working (Resident Load)

Mon, 04 Feb 2013 15:52:10 GMT

Hello,

I have the below script;

QUALIFY *;

Chart3:

LOAD

AuditPhase,

AuditPhaseID,

[Region Only],

NumYearMonth,

[DDQ Submit]

Resident TABLE1

Where NumYearMonth = 27 and

[AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD';

The NumYearMonth = 27 filter is not working, and after I run the script I still have all values in the new Chart3 table.

NumYearMonth is a created field using the autonumber() function.

swuehl — Mon, 04 Feb 2013 16:11:48 GMT

What are you trying to achieve with your where clause? Are you maybe looking for

Where NumYearMonth = 27 and

( [AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD' );

Please note the additional bracketing.

Mon, 04 Feb 2013 16:45:32 GMT

Thank you swuehl, that DID IT!!!

I have opened a new question title "Help with Where clause" is related to the same case, I would appreciate if you can have a look.

Thank you!!!