Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Error in Section Access

Good Morning Everyone,

I'm having some issues with section access.  Here is the error message I'm receiving:  What am I missing?  Thanks

The following error occurred:
Field 'Node1' not found
 
The error occurred here:
LOAD "ACCESS", "USERID", SAPROFITCENTER, [Node1], [Node2], [Node3], [Node4], [Node5], [Node6], [Node7], [Node8], [Node9] FROM [lib://QVD/Section Access/SAUsers.QVD] (qvd)
 
Here is my script:
 

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LET vToday = today();
Let vCYear = year(vToday);
LET vPYear = year(vToday) - 1;
LET vPrevYear = vYear - 5;
LET vRolling4 = makedate(vYear - 5, month(vToday), 1); // rolling 4 years
LET vRolling3 = makedate(vYear - 4, month(vToday), 1); // rolling 3 years
LET vPrevToday = makedate(vYear - 2, month(vToday), 1);


LET vFormatToday = Num(vToday);

Let vFormatRunDate = date(vToday, 'YYYY-MM-DD');

Let vRunDate = date(vToday, 'YYYY-MM-DD');

Section Access;
LOAD
"ACCESS",
"USERID",
SAPROFITCENTER,
[Node1],
[Node2],
[Node3],
[Node4],
[Node5],
[Node6],
[Node7],
[Node8],
[Node9]
FROM [lib://QVD/Section Access/SAUsers.QVD] (qvd)
;
Section Application;

 

ExpandedNodes:
LOAD
[Node1],
[Node2],
[Node3],
[Node4],
[Node5],
[Node6],
[Node7],
[Node8],
[Node9],
ParentGroup,
Path,
NodeIDCostCenterName,
ParentIDGroup,
Node
FROM [lib://QVD/Section Access/ExpandedNodes.QVD]
(qvd);

ExpandedNodeNames:
LOAD
Level1,
Level2,
Level3,
Level4,
Level5,
Level6,
Level7,
Level8,
Level9,
ParentCostCenterGroup,
"Davey Hierarchy",
NodeIDCostCenterName,
ParentIDCostCenterGroup,
Level,
DepthCostCenterGroup
FROM [lib://QVD/Section Access/ExpandedNodeNames.QVD]
(qvd);

AncestorNodes:
LOAD
NodeIDCostCenterName,
AncestorIDCostCenterGroup,
AncestorNameCostCenterGroup,
DepthDiffCostCenterGroup
FROM [lib://QVD/Section Access/AncestorNodes.QVD]
(qvd);


ProfitCenters:
LOAD
NodeIDCostCenterName,
"Profit Center",
SAPROFITCENTER,
"Profit Center Name",
"PC Desc"
FROM [lib://QVD/Section Access/CostCenterGroupHierarchy.QVD]
(qvd);

Exit Script;

Labels (2)
1 Solution

Accepted Solutions
tmumaw
Specialist II
Specialist II
Author

All rows in Section Access need to be in uppercase:

Upper([NODE1] as NODE1 

View solution in original post

1 Reply
tmumaw
Specialist II
Specialist II
Author

All rows in Section Access need to be in uppercase:

Upper([NODE1] as NODE1