Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

b_garside
Valued Contributor

Section Access not reducing

The attached QVW is suppose to reduce based on ROLE to Hide some sheets.

Based on the script,  what may I be doing wrong? I apologize for not being able to reload this.

Perhaps there is enough to tell what is wrong.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Section Access not reducing

This is your data?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, ROLE

    USER, WBBINC.COM\BGARSIDE, OPERATIONS

];

In this case try with domain WBBINC only.

Regards

8 Replies
Not applicable

Re: Section Access not reducing

Hi Brian

It's hard to guess without source data, but are values in ROLE column on RoleAccess spreadsheet in uppercase?

BTW, if this is not going to be only a test check "prohibit binary load" in Document Properties => Opening.

Lukasz

b_garside
Valued Contributor

Re: Section Access not reducing

Yeah its all upper case. Plus I use Upper(). Perhpas I need to remove Access since ROLE is taking place of that field?

ACCESSNTNAMEUSERROLE
USERMYDOMAIN\BGARSIDEBGARSIDEOPERATIONS
Not applicable

Re: Section Access not reducing

You're using UPPER() in Security table - what about SHEET_ACCESS table? If one of them in uppercase and other one lowercase they won't join to each other.

"ACCESS" is not a problem here. According to your example user BGARSIDE should be able to see all rows in SHEET_ACCESS which have OPERATIONS role assigned.  

What's USER column? Does this supposed to be USERID?

b_garside
Valued Contributor

Re: Section Access not reducing

Yep all uppercase.  maybe it is USER > USERID.  I was lost on that one.

I even tried a manual inline and it wasn't working.

ROLEDASHBOARDMARKETSACTIVEPIPEACTIVEOPPPROPFORECASTWINRATESBOOKINGSMARKETPOSEXCELREPORTFORMTRENDSBDSALESPLANNINGADMIN
ADMIN111111111111111
EXECUTIVE011110000000000
BD001110000000000
OPERATIONS000010000000000
b_garside
Valued Contributor

Re: Section Access not reducing

I thought NTNAME and the reduction field is all I really need? 

Not applicable

Re: Section Access not reducing

Also try this...

Go to Document Properties in settings tab.... go to sub tab "Opening" and select "Strict Exclusion"

Not applicable

Re: Section Access not reducing

Hi Brian,

I tested your application with an excel created by me and the reduction work correctly.

I think that this can be for the data introduced at section access. Can you give me your domine/user to set this as data and post my test for you?

Regards.

Not applicable

Re: Section Access not reducing

This is your data?

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, ROLE

    USER, WBBINC.COM\BGARSIDE, OPERATIONS

];

In this case try with domain WBBINC only.

Regards

Community Browser