Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandermllr
Creator
Creator

Qlikview - Where not by ID

Hello,

I want to join a table, but when the field action is "action 1" it should not join, but also not all other lines in the ID

IDaction
123action 1
123action 2
123action 3
456action 2
456action 5

 

Result:

IDaction
456action 2
456action 5

 

Thank for the help!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

tmp:
LOAD ID FROM ...source... WHERE action = 'action1';

IDs:
LOAD ID FROM ...source.. WHERE Not Exists(ID);

DROP TABLE tmp;

data:
LOAD ID, action WHERE Exists(ID);

DROP TABLE IDs;

 


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

tmp:
LOAD ID FROM ...source... WHERE action = 'action1';

IDs:
LOAD ID FROM ...source.. WHERE Not Exists(ID);

DROP TABLE tmp;

data:
LOAD ID, action WHERE Exists(ID);

DROP TABLE IDs;

 


talk is cheap, supply exceeds demand
alexandermllr
Creator
Creator
Author

Thank you very much! 🙂