topic Re: How Use a SQL Query in Qlikview in QlikView

How Use a SQL Query in Qlikview

Fri, 25 Apr 2014 19:33:49 GMT

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

fernando_tonial — Fri, 25 Apr 2014 19:40:50 GMT

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.

Fri, 25 Apr 2014 19:48:19 GMT

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 — Fri, 25 Apr 2014 20:03:36 GMT

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.

Anonymous — Fri, 25 Apr 2014 20:25:21 GMT

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

Load *;

Paste your sql query;