Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Delete data after reload

Hello:

The question is:

After reload data to my qlickview, with one SQL SELECT, is possible delete rows of this data, with some command? for example

After SQL SELECT

DATENunberCodAMOUNT
11/10/201010cod110
19/10/201020cod1115
12/11/201022cod1200
23/12/201030cod325
15/09/201040cod140
28/10/2010255cod1900
01/11/201030cod325
14/12/201015cod1100


The data with the same number drop

the result

DATENunberCodAMOUNT
11/10/201010cod110
19/10/201020cod1115
12/11/201022cod1200
15/09/201040cod140
28/10/2010255cod1900
14/12/201015cod1100


Any idea?

Thanks!!, regards

Cèsar Estrada

3 Replies
Not applicable

Delete data after reload

Hi there, I dont quiet undertand the pattern you want to remove, do you want to remove rows with Amount equal to 25?? or rows with Cod equal to 30cod3??

For either case try something similar to the following:

Table:

Load *

where Cod <> '30cod3';

sql select *

from database;

Regards

Not applicable

Re:Delete data after reload

Hi Ivan

I need delete row with the combination with the same number, code and amount.

Thanks!

Not applicable

Re:Delete data after reload

Hi there, one thing i forgot is that is not recommended to do any filtering while you are load from the database, because it affects performance, for instance you can save the table in a qvd.

Try something similar to the following:
Test:
//replace with your sql load
LOAD * INLINE [
Prod, Date, Amount
A, 10/02/2000, 25
A, 11/02/2000, 25
B, 10/02/2000, 30
B, 20/02/2000, 30
B, 23/02/2000, 20
C, 1/02/2000, 45
D, 21/02/2000, 50
D, 22/02/2000, 50
];
store Test into Test.qvd;
drop table Test;
Test:
Load Prod, date(max(date#(Date,'DD/MM/YYYY'))) as Date, only(Amount) as Amount
from Test.qvd (qvd)
group by Prod, Amount;

Regards.