topic Re: Section Access through QVD in QlikView

Section Access through QVD

ksasidhars — Fri, 21 Dec 2012 03:16:46 GMT

Hi -

Below is the code I'm using for section access implementation. But it always fails. Could you please let me know if we can code this way, from the QVD? if yes, kindly let me know if any mistake in my code. Thanks a lot

SECTION Access;

LOAD ACCESS,

NTNAME,

A_CD //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

SECTION Application;

Plz let me know if you need any kind of details. Thanks - Sasi

Re: Section Access through QVD

Fri, 21 Dec 2012 07:04:03 GMT

Hi,

I think there is some bug in QV11 to load section access table from qvd.

to do this we need to use where clause. try this...

SECTION Access;

LOAD ACCESS,

NTNAME,

A_CD //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd) where 1=1;

SECTION Application;

Niranjan M.

Re: Section Access through QVD

Fri, 21 Dec 2012 07:37:28 GMT

Hi Sasi,

The Field that you want to be reduce should be in the: SECTION Application;

Somthing like

SECTION Access;

LOAD ACCESS,

NTNAME,

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

SECTION Application;

LOAD

NTNAME,

A_CD //This is one Field on I need to do Section Access

FROM $(vQVD)/USER_ACCESS.QVD

(qvd);

And also tou need to check :

Check the selected option “Settings” -> “Document Properties” -> “Opening” ->Initial Data ReductionBased on Section Access:

Hope it helps,

Regards

Yigal

Re: Section Access through QVD

ksasidhars — Fri, 21 Dec 2012 14:55:25 GMT

Niranjan/Yigal,

Thanks all for your help guys.

I do agree with Yigal and Niranjan's trick is awesome though. Thank you once again

-Sasi

PS - Thanks a lot Yigal for your cool explanation with example/pictures.