Discussion Board for collaboration on QlikView Scripting.
I have the below script;
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.
Go to Solution.
What are you trying to achieve with your where clause? Are you maybe looking for
( [AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD' );
Please note the additional bracketing.
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.