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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How Use a SQL Query in Qlikview

I have a query like this in SQL Developer and I need bring that in QlikView .

I worte in Qlikview like this (Which is Attachment). Is it rgt?  if not how to do it. please help

Please find the attachements.

Thanks in advance

1 Solution

Accepted Solutions
fernando_tonial
Employee
Employee

Change your script.

instead

Join


change for this

Inner Join

Past your script and SQL query on post, can you help more.

Best Regards.

Tonial.

Don't Worry, be Qlik.

View solution in original post

4 Replies
fernando_tonial
Employee
Employee

Just Copy and Past your SQL in Script Editor

Like this:

Table:

SQL Select *

From Tab1, Tab2, Tab3

Where Tab1 = Tab2

  and Tab2 = Tab3

Kinds Regards.

Tonial.

Don't Worry, be Qlik.
Not applicable
Author

I just simply copied my SQL query in Qlikview.

Now?

I already imported the tables and fields. How can we achieve the same like I shown in the screen shot
?

Thanks

fernando_tonial
Employee
Employee

Change your script.

instead

Join


change for this

Inner Join

Past your script and SQL query on post, can you help more.

Best Regards.

Tonial.

Don't Worry, be Qlik.
Anonymous
Not applicable
Author

OLEDE...................

Load *;

Paste your sql query;