Section access is not working with multiple columns : Need help

dilip1234 — Mon, 09 Apr 2018 08:12:32 GMT

Hi All,

I have 3 tables:

Table: GEO

Column: GEONAME

Table: ZONE

Column: ZONENAME

Table: COUNTRY

Column: COUNTRYNAME

Now in my application one user can have access of multiple column wise details like:

Dilip can have access of some Geos, Zones and Countries as well. Right now I have section access query for Geo only and that is working fine, but when I am trying with multiple columns it now working.

Working section access script is like below:

SECTION ACCESS;

LOAD * INLINE

[

ACCESS, USERID, GEONAME

USER, INTERNAL\SA_SCHEDULER, *

USER, DIR\DILIP.SOLANKI, CANADA

USER, DIR\DILIP.SOLANKI, JAPAN

USER, DIR\DILIP.SOLANKI, INDIA

USER, DIR\J.A.SASIKUMAR, INDIA

];

SECTION APPLICATION;

Note: My all tables Geo, Zone and Country is not linked together, I am using these all in Geo analytics map, where I have requirement which doesn't allow me to link these tables.

I was trying like this:

SECTION ACCESS;

LOAD * INLINE

[

ACCESS, USERID, GEONAME, ZONENAME

USER, INTERNAL\SA_SCHEDULER, *, *

USER, DIR\DILIP.SOLANKI, CANADA, *

USER, DIR\DILIP.SOLANKI, JAPAN, *

USER, DIR\DILIP.SOLANKI, INDIA, NORTH ZONE

USER, DIR\J.A.SASIKUMAR, INDIA, SOUTH ZONE

];

SECTION APPLICATION;

Can anyone tell me that how to achieve this kind of scenario?

Thanks

Dilip Solanki

Re: Section access is not working with multiple columns : Need help

rubenmarin — Mon, 09 Apr 2018 08:58:07 GMT

Hi Dilip, '*' in section access means all listed values, not all values of the field.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularStatements/Star.htm

So DILIP.SOLANKI can access JAPAN-NORTH ZONE or JAPAN-SOUTH ZONE, but the user can't reach other zones of JAPAN.

If this is what is happening you can load all zone values, seems this can work with your sample data, but for more complex data maybe you need a composite key:

Data Reduction Using Multiple Fields

Basics for complex authorization

topic Section access is not working with multiple columns : Need help in QlikView

Section access is not working with multiple columns : Need help

Re: Section access is not working with multiple columns : Need help