topic Error when trying to make QVD files in QlikView

Error when trying to make QVD files

francisvandergr — Mon, 26 Jan 2026 18:19:17 GMT

I am trying to make some QVD files. But i get an error. Do someone know what i can do to let it work.

Error when trying to make QVD files

suniljain — Thu, 24 Mar 2011 06:46:00 GMT

Binary Load statement Must be first statement in your script. pls check that things.

Error when trying to make QVD files

francisvandergr — Thu, 24 Mar 2011 06:57:30 GMT

This is my first line:

Binary F:\Qlikview\Documents\Superusers\Orffa_Werkkapitaal.qvw;

When i start manualy the file Orffa_Werkkapitaal.qvw, i have buid in a login. DO i have also use this login in my binary line ? And how ?

Error when trying to make QVD files

Thu, 24 Mar 2011 06:58:00 GMT

use following syntax.

Web_track_Appts:
LOAD CLIENTID,
TERRITORY_NAME,
APPLY_CNT;
SQL SELECT *
FROM web_track_appts;
Store Web_track_Appts into Datasources/web_track_appts.qvd;

The Data source folder should be at the same place as that of the .qvw file.

Enjoy:)

Error when trying to make QVD files

gauravkhare — Thu, 24 Mar 2011 07:05:02 GMT

Dear Francis Vandergrijn,

you just cannot apply binary load when you have implemented security in you qvw!!!!!!!!!!!

Kindly remove those security related things and then the binary load will work.

Error when trying to make QVD files

Thu, 24 Mar 2011 07:20:12 GMT

Agreed with Gaurav

Reference manual says Binary statement can be first line only and security also hence they will collide if implemented in one file.

do this way

implement security in file A

do binary load of file A in File B.

Reg,

Shubhu

Error when trying to make QVD files

francisvandergr — Thu, 24 Mar 2011 08:17:03 GMT

I have no security in my files anymore. It still don't work

Error when trying to make QVD files

suniljain — Thu, 24 Mar 2011 09:21:19 GMT

Pls Check Document Properties-> Opening ->Prohibit Binaryload

Error when trying to make QVD files

francisvandergr — Thu, 24 Mar 2011 09:42:46 GMT

that was the answer. I tagged him out and it works.

Thnx