Section Access

[#1]

Hi,

i am new to Qlikview and trying to implement section access, i want to restrict data by Division(Field DIV) in my document. i have created NT section access, looks like its working but i noticed some data missing when i open the document from Access point. i was able to see that data if i open the document in personal edition. can someone please let me know if i'm doing something wrong in here.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME , DIV

    ADMIN, PANTHER\HARISHB, NE

    ADMIN, PANTHER\HARISHB, SE

    ADMIN, PANTHER\HARISHB, W

    ADMIN, PANTHER\BENHAN, NE

    ADMIN, PANTHER\JOEMAN, NE

    ADMIN, PANTHER\QLIK00.SERVICE, *

    USER, PANTHER\JIMMYK, NE

];

Section Application;

SalesmanDimension:

LOAD

      DIV

FROM

$(vPath)SalesmanDimension.qvd

(qvd);

Below is the actual table that has DIV field.

SalesmanDimension:

LOAD

    ACCT_NO AS SalesCode,

    FIRST,

     LAST,

     Name,

     MI,

     DIV,

     Email,

     REGION_MGR,

     UserName,

     ACCT_NO & ' - ' & Name AS SalesName

FROM

$(vPath)SalesmanDimension.qvd

(qvd);

[#2]

It has all the divisions that are in the salesman dimension.

[Anonymous]

its strange brother. i will share my script. lets see if that helps you

[#4]

Thanks, Vinay! appreciate you help.

[Anonymous]

	section access;
	access:
	LOAD
		upper(NTNAME) as NTNAME,
		[ACCESS],
		upper(DIVISION) as DIVISION,
		[GROUP],
		upper(SALESPERSON) as [SALESPERSON]
	FROM
	[$(ASIExcelDir)NT_Auth-Asg.xls]
	(biff, embedded labels, table is Sheet1$);

	section application;
	OCUSMA:
	LOAD
		upper([Customer number]) as [SALESPERSON],
		[Customer number] as Salesperson,
		[Customer number] as Salesperson1,
		[Customer name] as [SalesRep Name],
		upper(DIVISION) as DIVISION

	Resident TempOCUSMA;
	Drop Table TempOCUSMA;

[Anonymous]

sometimes use Trim infront of all the columns that will remove any unwanted space

[jafari_ervin]

Maybe there are related between Rev Budget and GP$ Budget and your reduction field.

[#8]

Thanks, Everyone! one of our designer had a calculated dimension on that chart, that's the reason those numbers were not showing up! really appreciate all your help.

[Anonymous]

Glad you were able to figure out that . Just close this thread by making correct answer and mark if anything seems helpful.

[#10]

Sure! thanks again.

[Anonymous]

thank you for closing the thread