Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

QV read SQL data it is possible to do not near accounting server ?

Hi All

I use to work in indonesia , due to my area internet access very slow or no internet access.

My question is it is possible for me to read the SQL data into QV and save the data as QVD file.

So that i can add code and data cleaning and create the time line and master calendar and to the extend i create report which user need.

Once it is okay , then i place the QV QVW file at SQL server and create batch for automatic reload and update data.

can some one advise me it is the right approach ?

Paul

1 Solution

Accepted Solutions

Re: QV read SQL data it is possible to do not near accounting server ?

You certainly can, pretty much as you suggest ::

  • Create qvw to to read SQL data and store to qvd file
  • Copy qvd file to your local computer
  • Create qvw to load qvd data an visualize it h charts / tables etc
  • Copy completed qvw back to server and reload with data from server qvd file
1 Reply

Re: QV read SQL data it is possible to do not near accounting server ?

You certainly can, pretty much as you suggest ::

  • Create qvw to to read SQL data and store to qvd file
  • Copy qvd file to your local computer
  • Create qvw to load qvd data an visualize it h charts / tables etc
  • Copy completed qvw back to server and reload with data from server qvd file
Community Browser