Discussion board where members can get started with QlikView.
I'm totally new in QV.
I got 2 table. like this
Country , Zone....
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 ^^
Go to Solution.
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.
Thank you for post. Can u please send me your example.
I think example will be clear to me.
well i solved my problem. The problem was i wrote where exists function wrong that all ^^.
Thank you Manesh