Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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.

View solution in original post

3 Replies
Highlighted

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.

View solution in original post

Highlighted
Not applicable

It works well.

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

Highlighted
Contributor II
Contributor II

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