topic Section Access issue - qlikview in QlikView

Section Access issue - qlikview

gidon500 — Thu, 03 Mar 2016 15:39:57 GMT

I have a long table with FAMP filed , that represent manufacturer

ACCESS	USERID	PASSWORD	FAM
ADMIN	G	D	*
USER	D	D	INTEL
USER	A	A	DELL
USER	B	B	EPSON

using this table I get access denied . but when I change to :

ACCESS	USERID	PASSWORD	FAM
ADMIN	G	D	*
ADMIN	D	D	INTEL
ADMIN	A	A	DELL
ADMIN	B	B	EPSON

all is OK user D get intel only , A gets dell only and B gets EPSON only

G see them all .

but now they are all admin , which is very bad for me

what am I doing wrong , is there a flag I need to change

thanks for your help

gidon

Re: Section Access issue - qlikview

Peter_Cammaert — Thu, 03 Mar 2016 15:45:23 GMT

IMHO this behavior cannot be explained form the information you provided. We could start guessing for the other details, but it would be more helpful if you could upload a small exampel document that exhibits this behavior. Can you do that?

Best,

Peter

Re: Section Access issue - qlikview

gidon500 — Thu, 03 Mar 2016 15:49:40 GMT

ok will try it is big file

Re: Section Access issue - qlikview

Peter_Cammaert — Thu, 03 Mar 2016 15:55:30 GMT

You don't have to add any data except for a single Section Application table to which the FAM field can link to.

Re: Section Access issue - qlikview

gidon500 — Thu, 03 Mar 2016 17:18:44 GMT

Hi Guys

I have found the problem ,

it seems that in earlier stage of the ERD build

I have used a FIELD name USERID ,

this caused the problem ,

when loading the data qlik did not advise an error

I have removed the table of users

it is OK

I think the when loading should be an error on load of data

gidon