topic Re: Section Access in QlikView

Section Access

Wed, 01 Oct 2014 10:43:33 GMT

Hi,

I have implemented a section access that work fine when I log in a user with "ACCESS" = ADMIN, but if the user has "ACCESS" = USER I can't log in!

Any suggestions?

Thanks in advance,

Francisco

Re: Section Access

simondachstr — Wed, 01 Oct 2014 10:46:02 GMT

Can you c/p the section access code?

Everything between Section Access; and Section Application;

Re: Section Access

Wed, 01 Oct 2014 11:05:36 GMT

	Section Access;
	Directory;
	LOAD ACCESS,
	USERID,
	PASSWORD,
	SalesTeamName as [SalesTeam], upper(SalesTeamName) as LEVEL1_SA, Level1 as [SalesTeam Level1], upper(Level1) as LEVEL2_SA
	FROM
	$(vPath_Config)$(vFilename)_SA.xlsx
	(ooxml, embedded labels, table is SalesRepsSA);

	Section Application;

Re: Section Access

simondachstr — Wed, 01 Oct 2014 11:25:35 GMT

From the application, in the document properties, Opening, remove the strict exclusion have have a look if you see any data when you open the document with user. Might be the case that no existing LEVEL1_SA & LEVEL2_SA have been specified.

In addition to that, also load USERID in upper case by using Upper(USERID) to make sure section access is properly applied. However, I doubt this could be the ultimate reason if you say access = admin works fine.

Re: Section Access

Wed, 01 Oct 2014 11:30:37 GMT

Thanks Martin!

It was the "Strict Exclusion"!