Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where exists?

Hello all

I'm totally new in QV.

I got 2 table. like this

tabel1:

Country , Zone....

AE, 1

AT, 2

AZ, 3

BA, 4

BZ, 5

CZ, 6

table2:

Country, Zone...

AE, 1

AZ, 3

Ba,4

i want to show only existing countries. I dont want to join them. Is there any way to do this.

Well i tried to use where exists function but no luck. Also i tried to search google and qv help but i didnt got any clear answers.

Can someone show me how to do this and describe it liiitle bit?

I know i got some synthetic keys and that's will be my next question ^^

1 Solution

Accepted Solutions
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

use the where exists(table1.country,table2.country)

use alise in table1 Country as Country1

and use in table 2 as where exists(Country1,Country)

it will work. Or post me i will send u a example.

View solution in original post

3 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

use the where exists(table1.country,table2.country)

use alise in table1 Country as Country1

and use in table 2 as where exists(Country1,Country)

it will work. Or post me i will send u a example.

Not applicable
Author

Hi Manesh

Thank you for post. Can u please send me your example.

I think example will be clear to me.

Not applicable
Author

well i solved my problem. The problem was i wrote where exists function wrong that all ^^.

Thank you Manesh