Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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);