Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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?
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.