Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Multiple reduction fields, access denied to this Qlikview document

I have a qlikview template which uses multiple reduction fields.

Some users do not have access to all data and therefore I use some reduction fields to prevent users to see all the data.

In the normal setup the reduction fields are working correctly. In an addapted version it is not working anymore as expected (i.e. I want to add some decoding of the passwords when loaded from the excel file)

I have added 2 examples qvw files (Security_OK, Security_WRONG)

In both example I use the same data: I have 2 reduction fields REGION and DEPARTMENT only the user access table is generate differently.

See here example of the users defined in the excel file which includes the access of the template

USERID PASSWORD ACCESS DEPARTMENT  REGION

USER1  USER1    USER   TOOLS       *

USER1  USER1    USER   INSTRUMENTS *

USER1  USER1    USER   APPLICATION *

USER1  USER1    USER   *           NL

USER1  USER1    USER   *           USA

USER1  USER1    USER   *           UK

USER1  USER1    USER   *           TW

USER2  USER2    USER   *           NL

USER3  USER3    USER   TOOLS       NL

USER4  USER4    USER   INSTRUMENTS *

What I expect is when I open the document with user 2, he will see all departments and only Region 'NL'.

In 'Security_OK' the reductions fields are working correctly. When I open the version 'Security_WRONG' I got the error 'access denied to this Qlikview document'.

USER3 is working correctly in both versions. The difference here is that both fields are defined.

Who could explain me why these 2 version of scripts behave differntly.

And how could i solve this as I want to be able to descrable the password loaded from the excel file using a function (not included in the current script)

Login as ADMIN (pw ADMIN) to be able to edit/open the script.