Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

a question about Section Access

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!

Tags (2)
2 Replies
Not applicable

Re: a question about Section Access

Please refer the attached application

Not applicable

Re: a question about Section Access

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.

Untitled.png