topic Re: Section access only on expression in QlikView

Section access only on expression

passionate — Sat, 11 Nov 2017 06:02:02 GMT

Hi Geeks,

Requirement:

I have different sets of User having below access:

ACCESS	USERID	Priority
ADMIN	1
USER	2	Priority GB clients
USER	3	CMB
USER	4	Non-Profit GB clients

Data:

Attached in excel

I have a straight table given below:

If i login with USERID :2.

I have access only to Priority GB clients

So,I require table showing sum(Sales) for Priority GB clients and for other priority it should show '0'

But, As per section access it is reducing Priority Records:

Any solution so that only expressions are affected by section access.

Thanks,

Pankaj

Re: Section access only on expression

karthikoffi27se — Sat, 11 Nov 2017 08:04:06 GMT

Hi Pankaj,

As per section access, it only shows as per the access given. Unfortunately there is no option to show the other fields with zero value.

Many Thanks

Karthik

Re: Section access only on expression

marcus_sommer — Sat, 11 Nov 2017 14:31:30 GMT

It's not possible with a normal section access implementation.

Thinkable is to chain the access rights to the data without section access and to query the user within the expression with something like:

sum({< AccessList = {"$(=osuser())"}>} Value)

I could imagine that a quite similar solution might be possible with section access in the way like the access-control worked by sheet- and/or object-level access by using a 0/1 flag against the data which might result in an expression like:

sum(Value) * AccessFlag

But both described approaches and similar ones are not really secure because the data itself will be available within the application. This meant it will be only some advanced kind of usability.

An alternatively could be to mask the data with section access like this way: Mask or de-identify data for certain users using Section Access.

More to section access: Section Access.

- Marcus