Discussion Board for collaboration on QlikView Scripting.
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?
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
It works well.
Thank you Miguel 🙂 It spent me several hours until your reply.
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?