a question about Section Access

Tue, 08 Oct 2013 04:41:36 GMT

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!

Re: a question about Section Access

Tue, 08 Oct 2013 04:51:27 GMT

Please refer the attached application

Re: a question about Section Access

Wed, 09 Oct 2013 02:29:02 GMT

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.

Thanks anyway.

topic Re: a question about Section Access in QlikView

a question about Section Access

Re: a question about Section Access

Re: a question about Section Access