topic Re: Export Section Access to QVD in QlikView

Export Section Access to QVD

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

How can I Export Section Access Table to a qvd?

Thnx,

Bernd

marcus_sommer — Thu, 11 Aug 2016 09:00:57 GMT

Couldn't you simply use:

store SectionAccess into SectionAccess.qvd (qvd);

- Marcus

berndjaegle — Fri, 12 Aug 2016 10:17:19 GMT

was not successful.

berndjaegle — Fri, 12 Aug 2016 10:27:21 GMT

Following works for me:

Create Tmp Table with Section Access Information.

Export table as QVD(!) and reload the QVD with "where 1=1"

tmp_SectionAccess:

LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME

ADMIN, admin, 1234, *
USER, user, , *

USER, test, test, MS\SCOTT];

tmp_SectionAccess into TmpSectionAccess.qvd (qvd);

drop Table tmp_SectionAccess ;

SECTION Access;
   LOAD
     ACCESS,
     USERID,
     PASSWORD,
     NTNAME
FROM
Tmp_SectionAccess.qvd (qvd)
WHERE 1=1;