Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stabben23
Partner - Master
Partner - 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
Anonymous
Not applicable

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

Anonymous
Not applicable

I guess:

LOAD

...

FROM...

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

Not applicable

the where clause should be

Where Subradlinje <> 0 and Type<> 4;

stabben23
Partner - Master
Partner - Master
Author

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

2015-04-23_1414.png

stabben23
Partner - Master
Partner - Master
Author

Sorry Michael,

you are right, forgot the bracket , thanks

Anonymous
Not applicable

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