topic Re: Deleting rows after doing lookup with fiels in QlikView

Deleting rows after doing lookup with fiels

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I need your help in the below mentioned logic(applied in Excel) to be implemented in Qlikview:

Select Flag=Y in report;

After the selection of Flag=Y, copy corresponding ID to another sheet. Named this sheet “Flag”;
Clear all filter conditions in report;
Insert one column “vlookup Flag Y” in report. Use “ID ” in report to do v-lookup with “ID ” in sheet Flag;
Filtered out IDs that can be found in column “vlookup flag Y” in report;
Delete these rows;

Below is a snapshot for reference:

Item	ID	Flag	Amount
A	12345678	N	100	If Flag is "Y" for this ID, then Should delete 1st and 2nd row (highlighted in Yellow)
B	12345678	Y	100
C	87654321	N	100

Thanks and Regards

Abhijit Mishra

tresB — Mon, 07 May 2018 11:08:03 GMT

Try like:

Master:

Load * Inline [

Item, ID, Flag, Amount

A, 12345678, N, 100

B, 12345678, Y, 200

C, 87654321, N, 300

D, 87654300, Y, 400

E, 87654321, N, 500

F, 87654322, Y, 500

F, 87654323, N, 600];

Map:

Load Distinct

ID as Exclude

Resident Master Where Flag='Y' ;

NoConcatenate

Final:

Load

Resident Master Where not Exists(Exclude, ID);

DROP Table Master, Map;

Anonymous — Mon, 07 May 2018 14:16:07 GMT

Thanks tresesco‌

It worked.