topic Where exists? in QlikView

Where exists?

Mon, 21 Feb 2011 13:39:00 GMT

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 ^^

maneshkhottcpl — Mon, 21 Feb 2011 13:44:52 GMT

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.

Mon, 21 Feb 2011 13:57:52 GMT

Hi Manesh

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

I think example will be clear to me.

Mon, 21 Feb 2011 15:20:56 GMT

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

Thank you Manesh