i got a question about section access:
i want USER1 to see the data from 'Area' A in 2013. While USER2 can see 'Area' B in the all year (2012,2013).
i edit the script like this:
section access;
load * inline
[ACCESS,USERID,PASSWORD,%AREA,%YEAR
USER,USER1,123,A,2013
USER,USER2,123,B,YEAR*];
SECTION APPLICATION;
LOAD * INLINE
[%AREA,Area
A,A
B,B
AREA*,A
AREA*,B
];
LOAD * INLINE
[%YEAR,Year
2012,2012
2013,2013
YEAR*,2012
YEAR*,2013
];
LOAD Year,Area,Sales
from .\sectionaccess.xlsx
(ooxml,embedded labels ,table is Sales);
the data in table Sales is :
Year Area Sales
2012 A 10
2012 B 20
2013 A 30
2013 B 40
B 50
A 60
notice that the value of field 'Year' is missing the last 2 lines of table 'Sales'.
when USER2 open this document, he see the data from Area B in both 2012 and 2013. But the total sale is 60 (=20+40). But not
110(=20+40+50).
How to avoid this when missing value exsits in restrict fields ?
My test qvw and xls file see the attachment.
thanks!
