Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
stabben23
Honored Contributor

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

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Delete rows

I guess:

LOAD

...

FROM...

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

View solution in original post

6 Replies
Not applicable

Re: Delete rows

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

mov
Esteemed Contributor III

Re: Delete rows

I guess:

LOAD

...

FROM...

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

View solution in original post

Not applicable

Re: Delete rows

the where clause should be

Where Subradlinje <> 0 and Type<> 4;

stabben23
Honored Contributor

Re: Delete rows

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

2015-04-23_1414.png

stabben23
Honored Contributor

Re: Delete rows

Sorry Michael,

you are right, forgot the bracket , thanks

sbobbyraj
Contributor III

Re: Delete rows

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