Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using INNER JOIN/LEFT OUTER JOIN in QlickView

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,

Labels (1)
10 Replies
Not applicable
Author

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........