topic SV:How to join in between tables? in QlikView

How to join in between tables?

Thu, 30 Jul 2009 13:54:08 GMT

Hi All,

Am trying to fetch the data from 5 tables (Customer,geography,product,time,scenario) from SQL server.Where 2 tables (customer and geography) are joined by automatically. (Am getting that from table viewer)

But still am getting data from all the tables in my sheet and the Time is getting affected according to the customer selection as well, even though they does not have any relations. So am wondering is the data shown is correct?

Else how do i write some custom script to set the relation?

Please help me out.

Thanks in advance,

Mahasweta

SV:How to join in between tables?

Thu, 30 Jul 2009 14:30:49 GMT

Qlikview logical connects fields with the same name so you need to either rename fields that aren't the same or use the qualify-command.

Customer: Load nm ....

Region: Load nm as region_nm ...

If this is not your problem please supply a sample of your loading script.

/Michael

How to join in between tables?

Thu, 30 Jul 2009 14:40:57 GMT

Mahasweta,

can you post the query you are using along with column names in your qlik doc?

-Raghu

SV:How to join in between tables?

Thu, 30 Jul 2009 16:42:30 GMT

Hi,

Thanks a ton for your reply.

Here i didnt write any script. Rather i have selected the fields from the sheet it self. so back end i got the script as below.

SQL SELECT * FROM AdventureWorksDW.dbo.DimScenario;;
//************************************************
LOAD TimeKey, FullDateAlternateKey, DayNumberOfWeek, EnglishDayNameOfWeek, SpanishDayNameOfWeek, FrenchDayNameOfWeek, DayNumberOfMonth, DayNumberOfYear, WeekNumberOfYear, EnglishMonthName, SpanishMonthName, FrenchMonthName, MonthNumberOfYear, CalendarQuarter, CalendarYear, CalendarSemester, FiscalQuarter, FiscalYear, FiscalSemester;
SQL SELECT * FROM AdventureWorksDW.dbo.DimTime;;
//************************************************
LOAD CustomerKey, GeographyKey, CustomerAlternateKey, Title, FirstName, MiddleName, LastName, NameStyle, BirthDate, MaritalStatus, Suffix, Gender, EmailAddress, YearlyIncome, TotalChildren, NumberChildrenAtHome, EnglishEducation, SpanishEducation, FrenchEducation, EnglishOccupation, SpanishOccupation, FrenchOccupation, HouseOwnerFlag, NumberCarsOwned, AddressLine1, AddressLine2, Phone, DateFirstPurchase, CommuteDistance;
SQL SELECT * FROM AdventureWorksDW.dbo.DimCustomer;;
//************************************************
LOAD GeographyKey, City, StateProvinceCode, StateProvinceName, CountryRegionCode, EnglishCountryRegionName, SpanishCountryRegionName, FrenchCountryRegionName, PostalCode, SalesTerritoryKey;
SQL SELECT * FROM AdventureWorksDW.dbo.DimGeography;;
//************************************************
LOAD GeographyKey, City, StateProvinceCode, StateProvinceName, CountryRegionCode, EnglishCountryRegionName, SpanishCountryRegionName, FrenchCountryRegionName, PostalCode, SalesTerritoryKey;
SQL SELECT * FROM AdventureWorksDW.dbo.DimGeography;

Now please do suggest me .

Thanks & Regards,

Mahasweta

SV:How to join in between tables?

Thu, 30 Jul 2009 17:24:46 GMT

If you can see the Last 3 LOAD statements the "GeographKey" is the common field. These 3 tables will be linked together. But i don't see any link with the first LOAD statement.

-Raghu

SV:How to join in between tables?

Thu, 30 Jul 2009 17:40:52 GMT

That means i should not fetch the data from other tables where there is no link, but i am able fetch the data from other tables as well. OR am i getting the wrong data there/ PLease guide me. Sorry am a beginer ,so asking some basic questions. Thanks, Mahasweta

SV:How to join in between tables?

Thu, 30 Jul 2009 17:50:00 GMT

"i should not fetch the data from other tables where there is no link"

ANS: No, You can fetch data without having link between tables.

But if you want to join between tables you have to be careful to link the fields. Data won't be wrong, you are getting the right data.

-Raghu.

SV:How to join in between tables?

Thu, 30 Jul 2009 18:29:05 GMT

Thanks a ton Raghu...

So if am getting correct data then no need to worry for the links in the back end.

Regards,

Mahasweta