topic Re: Section Access with Null reduction in QlikView

Section Access with Null reduction

vijetas42 — Thu, 08 Feb 2018 09:42:04 GMT

Hi All,

I have a requirement like if any user is not assigned with any reduction field value and also strict exclusion is there on document so still user can be able to see data from other table,

suppose,

section access;

load * inline[

ACCESS,NTNAME,REDUCE

USER,ab123,

];

section application;

load * inline[

REDUCE

];

load * inline[

CITY

City1,

City2

];

and also document is having strict exclusion.

Now, when user opens document it shows access denied but it works fine with ADMIN.so is there any way to handle this scenario to let the user open document and should see values from city.

Re: Section Access with Null reduction

vijetas42 — Thu, 26 Apr 2018 11:44:36 GMT

When I concatenate dummy record with it works but is there any work around like,if there is no reduce data present for user then only concatenate dummy else as is

Re: Section Access with Null reduction

Peter_Cammaert — Thu, 26 Apr 2018 11:52:33 GMT

Yes, this is possible. Add a second Link field that connects to the City table. For user ab123, all data in tables connected to the REDUCE table will be reduced away, but the CITY table will still contain data.

You may have to rethink your data model though. One solace: Section Access will not create circular references.

Re: Section Access with Null reduction

vijetas42 — Thu, 26 Apr 2018 12:28:58 GMT

Thanks for your reply but, couldn't get that second link field that connect to city table as in?can you please elaborate

Re: Section Access with Null reduction

Peter_Cammaert — Thu, 26 Apr 2018 14:20:49 GMT

Just add a CITY field to your Section Access table to get a Link Field that blocks the "Access Denied" situation because of total data reduction.

Re: Section Access with Null reduction

vijetas42 — Fri, 27 Apr 2018 06:19:53 GMT

If I add CITY field in section access table like,

section access;

load * inline[

ACCESS,NTNAME,REDUCE,CITY

USER,ab123,,A

];

and concatenate below two table

section application;

load * inline[

REDUCE

];

concatenate

load * inline[

CITY

City1,

City2

];

then user is able to see only assigned CITY which is A where, my requirement is to show all cities.

Re: Section Access with Null reduction

Peter_Cammaert — Fri, 27 Apr 2018 07:08:34 GMT

Maybe it's better if you first read a Section Access introduction like these:

A Primer on Section Access

Basics for complex authorization‌ and

QlikView Section Access Examples‌‌

From the second article, you can use the <ANY> trick to expand access rights stored in unique Section Access entries into all Cities.

A few additional remarks:

QlikView linkage is a strict value based affair. If link field values do not match, they won't produce links.
In Section Access fields, you could use asterisks ( * ) but those only expand to all values present in the Section Access column, not to the other values anywhere else in that same field in your data model. Pretty much useless if you don't put all CITY values in your Section Access table.
Don't throw your two tables CITY and REDUCE together. As I said before, Section Access cuts all circular references and works ok with different link fields as long as they are in different tables in Section Application. Keeps your data model tidy.

Best,

Peter