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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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........