topic Re: Big Section access error in QlikView

Big Section access error

nboccassini — Wed, 21 Jan 2015 11:24:16 GMT

Hi,

I have a section access on qvd like this (with 3000 rows):

SECTION Access;

Directory;

LOAD ACCESS,

NTNAME,

UTENTE,

APPLICATION

FROM

[SecurityGrid.qvd]

(qvd);

SECTION Application;

The reload of this file fails. Where is the error?

Thanks.

Gabriele

Re: Big Section access error

Wed, 21 Jan 2015 11:34:08 GMT

Can Please put the Error which one your getting while loading the Script

Re: Big Section access error

ashfaq_haseeb — Wed, 21 Jan 2015 11:37:22 GMT

Try this

SECTION Access;

Directory;

LOAD ACCESS,

NTNAME,

UTENTE,

APPLICATION

FROM

[SecurityGrid.qvd]

(qvd) where 1=1;

SECTION Application;

Note:

Section access cannot be applied on optimized qvd.

Regards

ASHFAQ

Re: Big Section access error

nboccassini — Wed, 21 Jan 2015 11:38:15 GMT

There isn't an error windows. The reload fails and appear a window that ask to me if reload the file.

Re: Big Section access error

nboccassini — Wed, 21 Jan 2015 11:39:30 GMT

It works! Thanks!

Re: Big Section access error

ashfaq_haseeb — Wed, 21 Jan 2015 11:39:50 GMT

Welcome

Regards

ASHFAQ

Re: Big Section access error

Wed, 21 Jan 2015 11:40:51 GMT

just concentrate on which ever i highlighted in script and use same script

SECTION Access:

Directory;

LOAD ACCESS,

NTNAME,

UTENTE,

APPLICATION

FROM

[SecurityGrid.qvd]

(qvd) where 1=1;

SECTION Application;