Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to join more than 2 tables in Qlikview

Hi All,

Can any one help me how to join more than 2 tables in Qlikview reports. i have read many articals but its seems dificult to me as i told to you i am a fresher. can any one share me with screen shots

Thanks,

Chiranjeevi.

4 Replies
p_verkooijen
Valued Contributor

Re: How to join more than 2 tables in Qlikview

Hi Chiranjeevi,

Not quite sure what you're looking for, please share more details.

Also you posted the discussion in the Qlik Sense Forums instead of QlikView

For more info about the Community, please check the Qlik Community Information

and Qlik Community Tip: Posting Successful Discussion Threads

MindaugasBacius
Valued Contributor II

Re: How to join more than 2 tables in Qlikview

The most effective way to solve your problem would be if you could share sample qvw.

Or create three example tables that will show your issue.

Not applicable

Re: How to join more than 2 tables in Qlikview

i am using like this i am getting data with this

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2008R2;Data Source=IB-SEZ-PC-089\sql2008r2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=IB-SEZ-PC-089;Use Encryption for Data=False;Tag with column collation when possible=False];

LOAD AddressID, AddressLine1, AddressLine2, City, PostalCode;

SQL SELECT AddressID, AddressLine1, AddressLine2, City, PostalCode FROM AdventureWorks2008R2.Person.Address;

LOAD AddressTypeID, Name;

SQL SELECT AddressTypeID, Name FROM AdventureWorks2008R2.Person.AddressType;

is this correct?

jolivares
Valued Contributor

Re: How to join more than 2 tables in Qlikview

Ok... the way to join tables, more than two, in pure QV script, is one at a time.  The best way you do that is making a SQL sentence and join all table that you need and bring the specifically data you need to process. Think that the SQL engine y more efficient than QV in this kind of task.  The beauty of QV is manage data in-memory.