How to join more than 2 column with OR operater from diffrentr QVD

[#1]

I have 2 QVD,One QVD has Column name as Coverage Region,this column join with another QVD which contain L2 Region and L4 region with OR condition.

becasue I don't want top miss any records in report.

Example--> Case when coverage type='All' then cov.CoverageRgion=CRM.L2region or cov.CoverageRegion=CRM.L4Region else Cov.Country=CRM.L2Country OR Cov.Country=CRM.L4Country.

How to use above condition in Edit Script.

Becaeu I think when I create Alise column in coverage qvd,it treat as and join.

so please let me know how to achive above thing in Qlik.

[DavidFoster1]

The joins (either in the script or the associative model) are implicit on the column name. The best approach I can think of for your problem is to cheat a bit. Can you load/concatenate the Region table twice so that you end up with the L2 and L4 regions in the same column/s.

[#3]

can you pls provide example for both.I tried but not resolve.

second we have created QVD from SQL..in that SQl we already use SQL logic,but in Qlik level how Ican use.pls provide me syntex.column from

[DavidFoster1]

So first of all in the first QVD (let us call it Coverage for ease) you need to derive a join key column.

LOAD

     *

     IF(coverage.type='All', cov.CoverageRgion,Cov.Country) as %CoverageScope

FROM Coverage.QVD; <<you get the idea

Regions:

LOAD DISTINCT

CRM.L2region                as %CoverageScope

CRM.L2regionname       as RegionName

FROM CRM.QVD

CONCATENTE (Regions)

CRM.L4region                as %CoverageScope

CRM.L4regionname       as RegionName

FROM CRM.QVD

CONCATENTE (Regions)

CRM.L2 Country                as %CoverageScope

CRM.L2countryname       as RegionName

FROM CRM.QVD

CONCATENTE (Regions)

CRM.L4Country                as %CoverageScope

CRM.L4Country       as RegionName

FROM CRM.QVD

[#5]

thanks for reply.

but in same case if I want to join in perticula case like if coverage.Type='ALL',we don't join with region but for other coverage type value we need to join.

how we do...pls tell me syntex.

[DavidFoster1]

Is the coverage type part of your data or a selection your are describing? If it is part of the data then the syntax above should work (look at the IF statement in the top part)

[#7]

I don't think this should we work,because I want show region avle but not join with other QVD region column.

Please help me out on syntex for tis.

if (coverage type='All','Don want region Mapping','Coverageregion') as CoverageScope

[DavidFoster1]

Sorry I dont understand what you are trying to achieve. I think you would need to provide an example.

[#9]

If coverage type "ALL",we don't need to join in Region level in edit script.

but when coverage type value is "Y" ,"N",I need to join with region in edit script on both QVD.

pls let me syntex for this.