Section Access Not Working as Expected

[#1]

Hi, I am new to QV. Try to add a section access (limit location) to an application. At first it seems worked but when I reload, the app shows all locations not just one I specifed. When I reload again, it will show one location again. Tried many times, looks like switching beteen one and all with each reload. Any expert has an idea? I searched the forum and didn't find a answer.  Here is my code: log in TTEST, will show between 0002 or all. And aslo affected other users. Like user MSIMPSON, if showing on mine only location 0002, his shows only that location even though he has right to access all.

Thank you very much for your any advices.

SECTION ACCESS;

LOAD NTNAME,
     LOCATION,
     [ACCESS]
FROM [.\LOCATION_CONFIG.xlsx] (ooxml, embedded labels, table is SectionAccess);

The .XLST file Like:

NTNAME                                        LOCATION           ACCESS         

TTEST                                                 0002                ADMIN

JDOE	*	ADMIN
JSMITH	0001	USER
MSIMPSON	*	USER
MSIMPSON	0002	USER
MSIMPSON	0003	USER
MSIMPSON	0004	USER
MSIMPSON	0005	USER

Jean

[hic]

Section Access will reduce data when you open the QlikView file. A reload will always load all the data specified by the script. Section Access does not affect which data gets loaded during the script run.

HIC

[#3]

Thank you HIC for your reply.  Maybe I didn't explained clearly. It happens when I open the Qlikview File. After reload, I open the file, it will show reduced data. If I reload again, open the file, it shows full set of data. Reload again, open file, show reduced data.. just this pattern.

[#4]

Thank you very much HIC for your quick reply. Maybe I didn't

explained clearly. It happens when I open the Qlikview File. After

reload, I open the file, it will show reduced data. If I reload again,

open the file, it shows full set of data. Reload again, open file, show

reduced data.. just this pattern.

>>> Henric Cronström<qliktech@sgaur.hosted.jivesoftware.com> 03/16/2012

1:47 PM >>>

QlikCommunity ( http://community.qlik.com/index.jspa )

Re: Section Access Not Working as Expected created by Henric Cronström

( http://community.qlik.com/people/hic ) in Community Help - View

the full discussion (

http://community.qlik.com/message/201813#201813 )

Section Access will reduce data when you open the QlikView file. A

reload will always load all the data specified by the script. Section

Access does not affect which data gets loaded during the script run.

HIC

Reply to this message by replying to this email -or- go to the message

on QlikCommunity ( http://community.qlik.com/message/201813#201813

)

Start a new discussion in Community Help by email (

mailto:message-community-community--help@qliktech.hosted.jivesoftware.com

) or at QlikCommunity (

http://community.qlik.com/choose-container!input.jspa?contentType=1&containerType=14&container=2001

)

© 1993-2011 QlikTech International AB Copyright & Trademarks (

http://www.qlik.com/us/info/copyright ) | Privacy (

http://www.qlik.com/us/info/privacy ) | Terms of Use (

http://www.qlik.com/us/info/terms-of-use ) | Software EULA (

http://www.qlik.com/us/info/software-eula )

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please contact the sender and delete/destroy all copies of this email and any related attachments. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.