4 Replies Latest reply: Jul 12, 2016 10:14 AM by Juan Olivares RSS

    How to join more than 2 tables in Qlikview

    Chiranjeevi Ramakrishna

      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.

        • Re: How to join more than 2 tables in Qlikview
          Paul Verkooijen

          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

          • Re: How to join more than 2 tables in Qlikview
            Mindaugas Bacius

            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.

              • Re: How to join more than 2 tables in Qlikview
                Chiranjeevi Ramakrishna

                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?