Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Where Exists function with 'and' ?

Hi,

I have a question about the Where Exists function. I'm using this to successfully load data from one table only where it exists in another (which I believe is proper use).

Example:

Where Exists ([First_ID], [Second_ID]);

However, from the table with the [Second_ID], I'd also like to specify a additional value to load.  Something like, load only values in Second_ID, where they have a match in First_ID, but also load '-1' from Second_ID.


Is something like this possible? Thanks in advance!


R.

for_qlik.png

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

Re: Where Exists function with 'and' ?

Where Exists ([First_ID], [Second_ID])

     OR [Second ID]=-1;

View solution in original post

3 Replies
Highlighted
Champion III
Champion III

Re: Where Exists function with 'and' ?

Where Exists ([First_ID], [Second_ID])

     OR [Second ID]=-1;

View solution in original post

Highlighted
Specialist
Specialist

Re: Where Exists function with 'and' ?

Hi Ryan,

You can try loading both separately and then concatenating results of those two.

Regards,
Pankaj

Highlighted
Contributor III
Contributor III

Re: Where Exists function with 'and' ?

Thanks Michael... I can't believe that was all there was to it -- I was really overthinking this one!