topic Re: Implementing Section access using QVD file data in QlikView

Implementing Section access using QVD file data

Tue, 23 Jun 2015 03:54:14 GMT

I am new to qlikview and trying to implement section access using data loaded into qvd file which has NTNAME and OperatingUnitDesc . After loading QVD file, i am loading contents into Hiddenscript tab to enable security which is throwing error.

Script:

SECTION ACCESS;
LOAD
ACCESS,
NTNAME AS NTNAME,
OperatingUnitDesc AS OperatingUnitDesc
FROM
C:\QlikView Projects\UDM\Development\QVD Generators\QVD\SecurityTable.QVD (qvd)
WHERE 1=1;
SECTION Application;
LOAD * INLINE [
OperatingUnitDesc
];

Error Message:

Field not found - <OperatingUnitDesc>

LOAD

ACCESS,

NTNAME AS NTNAME,

OperatingUnitDesc AS OperatingUnitDesc

FROM

C:\QlikView Projects\UDM\Development\QVD Generators\QVD\SecurityTable.QVD (qvd)

WHERE 1=

Please help in resolving the issue.

Thanks in advance

Re: Implementing Section access using QVD file data

Anonymous — Tue, 23 Jun 2015 04:04:53 GMT

Try changing your field headers to UPPER case

Re: Implementing Section access using QVD file data

jagan — Tue, 23 Jun 2015 04:10:21 GMT

Hi,

Check whether your QVD has OperatingUnitDesc column? and also you have to use Upper case for ACCESS and NTNAME.

SECTION ACCESS;
LOAD
Upper(ACCESS) AS ACCESS,
UPPER(NTNAME) AS NTNAME,
OperatingUnitDesc AS OperatingUnitDesc
FROM
C:\QlikView Projects\UDM\Development\QVD Generators\QVD\SecurityTable.QVD (qvd)
WHERE 1=1;

Re: Implementing Section access using QVD file data

Anonymous — Tue, 23 Jun 2015 04:16:03 GMT

Hi Jagan,

Quick question.

In section access can we keep lower cases like "OperatingUnitDesc" ?

Regards

Jeba

Re: Implementing Section access using QVD file data

hariprasadqv — Tue, 23 Jun 2015 04:22:44 GMT

That's not the recommended approach. Section access should have capitalized values always.

Re: Implementing Section access using QVD file data

jagan — Tue, 23 Jun 2015 04:24:49 GMT

We need to maintain in Upper case.

Refer this links

A Primer on Section Access

Data Reduction Using Multiple Fields

Regards,

Jagan.