topic Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView in QlikView

Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 09:09:43 GMT

Hello everyone,

I am very new to Qlickview and I am loving it. I am trying to do some reports for my sales department but I am currently stuck where I cannot join tables when I am in EDIT SCRIPT. I cannot seem to get it to work. I get an error saying Incorrect syntax near WHERE.

SQL SELECT * FROM NETSIS2014.dbo."VW_SATISTESLIM10"

LEFT OUTER JOIN TBLCASABIT WHERE TBLCASABIT.CARI_KOD=VW_SATISTESLIM10.ALTBAYI;

Sincerely,

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

anbu1984 — Tue, 22 Apr 2014 09:16:23 GMT

Replace where by ON

SQL SELECT * FROM NETSIS2014.dbo."VW_SATISTESLIM10"

LEFT OUTER JOIN TBLCASABIT ON TBLCASABIT.CARI_KOD=VW_SATISTESLIM10.ALTBAYI;

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 09:17:25 GMT

In QlikView, we don't require to write the field names on which to perform join as here u have mentioned TBLCASABIT.CARI_KOD=VW_SATISTESLIM10.ALTBAYI.

QlikView automatically joins the tables based on similar field name like:

SQL select ID,name from table1;

left join

SQL select ID,age from table2;

Here it will automatically join 2 tables based on field ID.

In ur example after left outer join u again need to write the select statement.

Hope this will help u..!

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 09:22:14 GMT

Have you generated QVD's??

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 10:43:05 GMT

I am new so I don't know what QVD means?

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 10:44:16 GMT

Edited my post. Got it to work. In case someone needs it;

SQL SELECT V.*, C.CARI_ISIM AS ALTBAYIISIM FROM TABLE1 V

LEFT OUTER JOIN TABLE2 C

ON C.CARI_KOD=V.ALTBAYI;

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 10:44:48 GMT

That is great to know thank you, but those tables field names are not the same sadly

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 10:51:16 GMT

If the field names are npot same u can rename it using 'as' keyword and make the alias of the same like in ur problem:

SQL SELECT ALTBAYI as CARI_KOD FROM NETSIS2014.dbo."VW_SATISTESLIM10"

LEFT OUTER JOIN select * from TBLCASABIT;

Hope this will help u..!

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 11:21:57 GMT

Tried but didn't help. I got it to work tho

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Tue, 22 Apr 2014 11:23:49 GMT

Can u post ur application?

Re: Using INNER JOIN/LEFT OUTER JOIN in QlickView

Wed, 23 Apr 2014 07:29:19 GMT

QVD is Qlikview Data, We might use different Source like XML, Access, Excel etc, Qlikview stores it in QVD format, which can be viewed using Qviewer. Try Generating some QVD's........