Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I need your help in the below mentioned logic(applied in Excel) to be implemented in Qlikview:
Select Flag=Y in report;
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
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;
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;
Thanks tresesco
It worked.