Implementing Section access using QVD file data

[#1]

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

[Anonymous]

Try changing your field headers to UPPER case

[jagan]

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;

[Anonymous]

Hi Jagan,

Quick question.

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

Regards

Jeba

[hariprasadqv]

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

[jagan]

We need to maintain in Upper case.

Refer this links

A Primer on Section Access

Data Reduction Using Multiple Fields

Regards,

Jagan.