Discussion Board for collaboration on QlikView Scripting.
I want to delete the the row with combination 0 and 4 (red) in my script. How will my where statment look like, I use qvd file.
Go to Solution.
WHERE NOT(Subradlinje=0 AND Type=4);
View solution in original post
Load * from Table where Orderrad=20 and subradlinje=0
the where clause should be
Where Subradlinje <> 0 and Type<> 4;
Michael, that was my first solution before I post in the community, but:
you are right, forgot the bracket , thanks
Are your fields Subradlinje and Type expressions or dimensions?
Because if they are expressions, then you have to identify the case where Subradlinje=0 AND Type=4 and make a where condition to exclude those case
Otherwise if they are dimensions, then use the condition:
WHERE NOT (Subradlinje=0 AND Type=4);