Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
stabben23
Master
Master

Delete rows

Hi,

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.2015-04-23_1400.png

1 Solution

Accepted Solutions
mov
Champion III
Champion III

I guess:

LOAD

...

FROM...

WHERE NOT(Subradlinje=0 AND Type=4);

View solution in original post

6 Replies
Not applicable

Load * from Table where Orderrad=20 and subradlinje=0

mov
Champion III
Champion III

I guess:

LOAD

...

FROM...

WHERE NOT(Subradlinje=0 AND Type=4);

View solution in original post

Not applicable

the where clause should be

Where Subradlinje <> 0 and Type<> 4;

stabben23
Master
Master
Author

Michael, that was my first solution before I post in the community, but:

2015-04-23_1414.png

stabben23
Master
Master
Author

Sorry Michael,

you are right, forgot the bracket , thanks

sbobbyraj
Creator III
Creator III

HI,

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);