Section access is not working with multiple columns : Need help

[dilip1234]

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

[rubenmarin]

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/ScriptRegularS...

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