Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Where clause not working (Resident Load)

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Where clause not working (Resident Load)

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.

2 Replies
MVP
MVP

Re: Where clause not working (Resident Load)

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.

Not applicable

Re: Where clause not working (Resident Load)

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!!!

Community Browser