Discussion Board for collaboration related to QlikView App Development.
I've got an issue with loading script.
In order to compare like for like, I want to exclude records where some specific fields are equal to 0 or 0.01.
I tried several things I found on the forum but they don't work. It's probably only a syntax issue but can't sort it.
Basically, I've got an excel file with something like
I want to import only the records where Field1 LY or Field2 LY or Field1 TY are not 0. Records A and B from the above table.
Where not(Field1 LY) like '0' or not(Field2 LY) like '0' or not(Field1 TY) like '0';
Where not(Field1 LY) like 0 or not(Field2 LY) like 0 or not(Field1 TY) like 0;
Where Field1 LY <> 0 or Field2 LY <> 0 or Field1 TY <> 0;
Where num(Field1 LY) <> 0 or num(Field2 LY) <> 0 or num(Field1 TY) <> 0;
I don't understand what's going wrong.
I would be greatful of any help.
Thank you all.
To only get records A & B you need to use AND as follows
Where Field1 LY <> 0 AND Field2 LY <> 0 AND Field1 TY <> 0;
View solution in original post
If that's a copy paste from your script, make sure you only use semicolon ";" after the last line of the statement and that you are using AND instead of several WHERE lines as Adrian explains above.
Thanks. It works.
Simply AND instead of OR...
All the WHERE lines were examples of what I tried., but I have only one in my script.
and yes it works with AND.