Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Section Access

I have narrowed my problem down to this.  I think I have a mismatch in the value in my section access table and the value in the reduction field.

Here is my inline table:

Section Access;

LOAD * INLINE [

    ACCESS, USERID ,SALESMANID  

    USER,DOMAIN\MRITTER,'2310'   

];

The reduction field (SALESMANID) is a text field and contains values like 209, 0209, n209.

If I put a value in my inline that contains a character like n209, then my section access works.  But if I put in a numeric value like 0209 then I get access denied.  I have verified that this value exists in the table. 

What do I need to do to make sure that the value in my section access is identical to the value in the table?  I tried using text() but that didn't change anything.

1 Solution

Accepted Solutions
Khan_Mohammed
Honored Contributor II

Re: Section Access

Section access;

Star is *;

LOAD * INLINE [

    ACCESS, USERID ,SALESMANID

    USER,INTERNAL\sa_scheduler,*

    USER,DOMAIN\MRITTER,2310

];

Section Application;

Try this?

The above script works for me in SA app if not check your USERID in text box by osuser() ?

And you should have your SALESMANID in Upper Case in your Fact or Dimension table, wherever that dimension is...

Ex: if SALESMANID is coming from Fact Table...

write

Upper (SalesManID) as SALESMANID and use SALESMANID in SA Inline code.

4 Replies
Khan_Mohammed
Honored Contributor II

Re: Section Access

Section Access;

LOAD * INLINE [

    ACCESS, USERID ,SALESMANID

    ADMIN,INTERNAL\sa_scheduler,*

    USER,DOMAIN\MRITTER,2310

];

Remove '  ' from the numeric value?

and maybe add Qlik Scheduler ID as Admin

rittermd
Honored Contributor

Re: Section Access

I have tried no quotes, single quotes, and double quotes and none of them work.

I added SA_Scheduler and that didn't work either.

Khan_Mohammed
Honored Contributor II

Re: Section Access

Section access;

Star is *;

LOAD * INLINE [

    ACCESS, USERID ,SALESMANID

    USER,INTERNAL\sa_scheduler,*

    USER,DOMAIN\MRITTER,2310

];

Section Application;

Try this?

The above script works for me in SA app if not check your USERID in text box by osuser() ?

And you should have your SALESMANID in Upper Case in your Fact or Dimension table, wherever that dimension is...

Ex: if SALESMANID is coming from Fact Table...

write

Upper (SalesManID) as SALESMANID and use SALESMANID in SA Inline code.

rittermd
Honored Contributor

Re: Section Access

Using Upper instead of Text on the field in the table worked.  Thanks

Community Browser