Discussion board where members can get started with QlikView.
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:
load * inline
LOAD * INLINE
(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
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
How to avoid this when missing value exsits in restrict fields ?
My test qvw and xls file see the attachment.
Please refer the attached application
Thank you Palla,
I opened you attachment. find that USER2 can only see Year '2013', but not the all Year.
I have ever tried your solution that using Asterisk to represent the all value in specified field. My conclusion is
that the '*' only contain the value shown in the section access.