Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

francisvandergr
Contributor II

Error when trying to make QVD files

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

Tags (1)
1 Solution

Accepted Solutions
suniljain
Honored Contributor

Error when trying to make QVD files

Pls Check Document Properties-> Opening ->Prohibit Binaryload

8 Replies
suniljain
Honored Contributor

Error when trying to make QVD files

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

francisvandergr
Contributor II

Error when trying to make QVD files

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 ?

Not applicable

Error when trying to make QVD files

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.

EnjoySmiley Happy

gauravkhare
Contributor

Error when trying to make QVD files

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.

Not applicable

Error when trying to make QVD files

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

francisvandergr
Contributor II

Error when trying to make QVD files

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

suniljain
Honored Contributor

Error when trying to make QVD files

Pls Check Document Properties-> Opening ->Prohibit Binaryload

francisvandergr
Contributor II

Error when trying to make QVD files

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

Thnx

Community Browser