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

[jagan]

Hi,

Only Qlikview Desktop can create the QVD file, other third party tools are not able to create the QVDs.  If you want to create QVD then you have create in Qlikview Desktop using the STORE command.  There is no other tools required for Qlikview to pull the data.

Example:

Data:

SQL SELECT

*

FROM TableName;

STORE Data INTO FileName.qvd;

From Excel to QVD:

Data:

LOAD

*

FROM FileName.xls;

STORE Data INTO FileName.qvd;

Hope this helps you.

Regards,

Jagan.

[Anonymous]

You rock. Thanks shankaree. Steep learning curve ☺

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Anonymous]

Thank-you so much. Sorry for the silly question but I’m not 100% on the terminology “desktop”. Shen you say “Only Qlikview Desktop can create the QVD files” , are you referring the “desktop” the Edit Script in the sheet?

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[jagan]

Yes, “desktop” the Edit Script in the sheet.

Regards,

jagan.

[Siva_Sankar]

Laura,

I am referring to the Qlikview application. In the qlikview application where you write your script or load your data.

When we say desktop, it means the application we open and do the development. But when you publish in server, and view in accesspoint, it becomes web version of qlikview.

[Anonymous]

Thank-you

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Anonymous]

Thank-you

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[Siva_Sankar]

FYI.

QlikView Desktop is a windows based desktop tool that is used by designers and developers to create 1) data model 2) to create the graphical user interface (or QlikView presentation layer-Dashboard). This always gets store in .qvw file format.

Once .qvw file is developed we keep it on QlikView server.

QlikView Server is responsible for communication between clients and the QlikView applications. QlikView Server loads QlikView applications into server memory and distributes to clients.

QlikView Publisher loads data from different data sources (oledb/odbc, xml, xls), reduces the QlikView application and distributes to a QlikView server. It allows looping, reducing and distributing also. This component significantly improves performance of RAM, CPU and QlikView applications.

[Anonymous]

And this command (below), qlikView will look to the VarDirectory to find the file correct?

LOAD

*

FROM FileName.xls;

STORE Data INTO FileName.qvd;

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

[jagan]

Hi,

Generate this from

Edit Script -> Table Files -> Browse -> Select the file

and give the STORE command manually.

Regards,

jagan.