Restrict Personal Data in Qlikview

Tue, 08 Aug 2017 12:27:03 GMT

Hi All,

I have following use case, and need your help to troubleshoot it.

Fact/DATA has following structure:

REGION	COUNTRY	DISTRICT	DATA	USER
ASIA	INDIA	INDIA-A	20	P
ASIA	INDIA	INDIA-A	30	Q
ASIA	INDIA	INDIA-A	70	R
ASIA	INDIA	INDIA-B	90	P
ASIA	INDIA	INDIA-B	10	Q
ASIA	SINGAPORE	SINGAPORE-A	100	P
ASIA	SINGAPORE	SINGAPORE-A	110	Q
ASIA	SINGAPORE	SINGAPORE-A	80	R
ASIA	SINGAPORE	SINGAPORE-B	60	P
ASIA	SINGAPORE	SINGAPORE-B	20	Q
ASIA	SINGAPORE	SINGAPORE-B	10	R

Section Access/Entitlement Table:

REGION	COUNTRY	DISTRICT	USER	ACCESS	FLAG
ASIA	INDIA	INDIA-A	P	USER	N
ASIA	INDIA	INDIA-A	Q	USER	Y
ASIA	INDIA	INDIA-A	R	USER	Y
ASIA	INDIA	INDIA-B	P	USER	N
ASIA	INDIA	INDIA-B	Q	USER	Y
ASIA	SINGAPORE	SINGAPORE-A	P	USER	N
ASIA	SINGAPORE	SINGAPORE-A	Q	USER	Y
ASIA	SINGAPORE	SINGAPORE-A	R	USER	Y
ASIA	SINGAPORE	SINGAPORE-B	P	USER	N
ASIA	SINGAPORE	SINGAPORE-B	Q	USER	Y
ASIA	SINGAPORE	SINGAPORE-B	R	USER	Y

Problem statement:

We first load fact and then load entitlement table. Entitlement of users to Fact/Data are dependent on REGION, COUNTRY, DISTRICT values set up in Access/Entitlements table.

We have further created a column FLAG in this table.

When Value of Flag=N for a particular user, he should not be able to access his own data, but should be able to see his peer data

that is, for USER=P, FLAG=N, then he must be able to visualize data for users Q and R but not his own data (USER P). In case FLAG=Y, data will reduce as expected(as shown in Section Access/Entitlement Table)

Please provide your inputs on this problem statement.

Thanks in advance for giving a thought on this .

topic Restrict Personal Data in Qlikview in QlikView

Restrict Personal Data in Qlikview