Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Contributor III

Where exists?

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.

3 Replies
maneshkhottcpl
Contributor III

Where exists?

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

Where exists?

Hi Manesh

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

I think example will be clear to me.

Not applicable

Where exists?

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

Thank you Manesh