topic Re: Delete rows in QlikView

Delete rows

stabben23 — Thu, 23 Apr 2015 12:05:02 GMT

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.

Thu, 23 Apr 2015 12:08:39 GMT

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

Anonymous — Thu, 23 Apr 2015 12:08:47 GMT

I guess:

LOAD

...

FROM...

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

Thu, 23 Apr 2015 12:09:35 GMT

the where clause should be

Where Subradlinje <> 0 and Type<> 4;

stabben23 — Thu, 23 Apr 2015 12:13:32 GMT

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

stabben23 — Thu, 23 Apr 2015 12:17:43 GMT

Sorry Michael,

you are right, forgot the bracket , thanks

Anonymous — Thu, 23 Apr 2015 12:21:30 GMT

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