Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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;