Converting SQL results (typically excel) to QVD to be used in QlikV

[Anonymous]

Hi,

I need to run a SQL script on an external database and then translate these results into .qvd to use in QlikView.  I have searched the community to understand how to do this.  There is lots and lots of information out there and I am getting a little confused.  Does anyone have or know of a demo I could watch to better understand how to run the full process?

Cheers,

Laura

[fkeuroglian]

Hi Laura, how are you?

You can run this sql in qlikview script and then store into a .qvd, all of this in qlikview

Try this:

Test:

LOAD *;

SQL SELECT

"your sql script";

Store *  from Test into TestSQL.QVD(QVD);

--------------------------------------------------------------------------------------------------------------

In qlikview you can run sql native and get the result and then store as qvd

Hope help, Fernando

[Anonymous]

thanks Fernando.  I was running the script in a separate SQL tool called Razor.  So are you saying I don't need to do this?  I can be using SQL native that is provided within QlikView?  If yes,  where do I go to use SQL native within QlikView please?

[fkeuroglian]

Laura, you can do this in Qlikview

In the script editor, when you put "SQL SELECT" the next will be the sql and qlikview knows that you will put direct the sql

for example see the image attached.

you see and example, that put direct the sql that i want.

hope helps, tell me if you need something!

Fernando

[Siva_Sankar]

Laura,

You can create the QVD from select query by using STORE command, please find below the sample script

Data:

select c .CustomerID, p.productID ,p. ProductName from Customers c, Products p;n.

STORE Data FROM QVDFileName.qvd;

If you have installed qlikview, go to edit script by pressing Ctrl + E to access Edit script window. Then write your sql and use store command like above and reload the dashboard pressing Ctrl + R. once the reload is completed, the qvd will be created and it will be found in the same path where your qvw file is saved.

[Anonymous]

thanks Fernando,  I understand now.

I'II give it a go.

[Anonymous]

thanks Shankarece.

[Anonymous]

Hi Again,

I am having issues directly connecting to the external database due to security reasons.  Whist I wait for a resolve can you please tell me how to convert an excel file to a .qvd file ?

[Siva_Sankar]

[Siva_Sankar]

  Laura ,

Same syntax, after loading your file you need to use Store command like above to create the qvd