Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to delete multiple lines Using keep

Hi,

Here my Concern is in this below table,The lines 11 and 12 have no data so i want to delete the multiple lines at a time  by using keep,,

Although im using this below to delete for single Table:

Cs:

LOAD CustomerID,

     SalesOrderID,

     ProductID,

     SalesAmount,

     OrderQty,

     Year

FROM

(ooxml, embedded labels, table is [Fact Table])

Where ProductID<>11;

Prod:

right Keep LOAD ProductID,

  

ProductName

FROM

(ooxml, embedded labels, table is Product);

1 Solution

Accepted Solutions
Highlighted

Re: How to delete multiple lines Using keep

I think you want to use

  ... Where OrderQty>0 ;

instead of hard-coding a ProductID.

Secondly, I would use a Left Keep instead. Then you keep the records in the first table loaded according to the where-clause, and remove records in the second table - records that have no counterpart in the first table.

HIC

View solution in original post

2 Replies
Highlighted

Re: How to delete multiple lines Using keep

I think you want to use

  ... Where OrderQty>0 ;

instead of hard-coding a ProductID.

Secondly, I would use a Left Keep instead. Then you keep the records in the first table loaded according to the where-clause, and remove records in the second table - records that have no counterpart in the first table.

HIC

View solution in original post

Highlighted
Not applicable

Re: How to delete multiple lines Using keep

thanks a lot Mr.Henric

My problem was solved with your suggestion.