Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Can section access load qvd files?

Hi, I want to load a table in section access. I find if load from excel, section access works. But it can't work when load table from qvd file.

So my question is Can section access load qvd files?

1 Solution

Accepted Solutions
MVP
MVP

Can section access load qvd files?

Hello,

Yes, section access will work when loading from QVD, but you need to do the load unoptimized, the following (bold part) will do

SECTION ACCESS; LOAD USERID, PASSWORD, ACCESSFROM FILE.QVD (QVD) WHERE 1=1;


Hope that helps.

3 Replies
MVP
MVP

Can section access load qvd files?

Hello,

Yes, section access will work when loading from QVD, but you need to do the load unoptimized, the following (bold part) will do

SECTION ACCESS; LOAD USERID, PASSWORD, ACCESSFROM FILE.QVD (QVD) WHERE 1=1;


Hope that helps.

Not applicable

Can section access load qvd files?

It works well.

Thank you Miguel Smiley Happy It spent me several hours until your reply.

bhushan006
New Contributor II

Re: Can section access load qvd files?

HI,

can you please explain that why we need to use where 1=1 condition while loading data from qvd in section access.

Is it mandatory to load data from un-optimized qvd only. Is there any documentation available for this?

thank you,

Bhushan

Community Browser