Security based on Selection of data

[#1]

Hi QlikExperts,

I have a question regarding restriction of data within fields, based on selections on another field. I have tried to put an example of the data below:

Actual Data: (possible values)

profile	department	customer	type
P0A	DeptA1	CustomerA1	Type1
P0A	DeptA1	CustomerA2	Type2
P0A	DeptA1	CustomerA3	Type1
P0A	DeptA1	CustomerB1	Type1
P0A	DeptA1	CustomerB2	Type2
P0A	DeptA1	CustomerB3	Type1
P0A	DeptB1	CustomerA1	Type1
P0A	DeptB1	CustomerA2	Type2
P0A	DeptB1	CustomerA3	Type1
P0A	DeptB1	CustomerB1	Type1
P0A	DeptB1	CustomerB2	Type2
P0A	DeptB1	CustomerB3	Type1

Security Part: (what should the user logged in with specific profile see)

profile	department	customer	type
P0A	DeptA1	CustomerA1	Type1
P0A	DeptA1	CustomerA2	Type2
P0A	DeptA1	CustomerA3	Type1
P0A	DeptB1	CustomerB1	Type1
P0A	DeptB1	CustomerB2	Type2
P0A	DeptB1	CustomerB3	Type1

As seen in the example above, Profile P0A should see only CustomerA1, CustomerA2 and CustomerA3 and the data in field type, when he selects DeptA1.

But when he selects DeptB1, he should see the relevant data as seen in the above table.

However, in section access I have mentioned P0A sees DeptA1 and DeptB1 only.

Please can someone help. Hope I have best described the problem case.

Thanks in advance,

Robinson

[IAMDV]

No problem Robinson.

I don't have time today but I'll look into this and get back to you ASAP.

Where are you based?

Cheers,

DV

www.QlikShare.com

[#3]

Thanks Deepak

[IAMDV]

Interesting! I saw your spreadsheet and it's complex for sure. Please can you also attach the application? It helps to test the script while working Section Access.

Thanks,

DV

www.QlikShare.com

[#5]

Hi Deepak,

Thanks.

I am following a different approach now. I am creating an Excel sheet (link table) with all the possible allowed selection criteria for the user login. Fields from this table will be given to the user for selections, so that ways the selections for each profile is controlled. And this would be linked to the main Fact table using a composite key of all fields.

Now, this way, I can also add n number of rows and flag then as 0 or 1. I will then check in the expressions for the flag and enable/disable them (for each possible selection criteria). Even here I am facing some issue with the ApplyMap function..

http://community.qlik.com/message/248835#248835

I am trying different ways to do this.

I am attaching the qvw (few data is scrambled) and the Excel file witht he possible combinations.

Thanks again for your help.

Thanks,

Robinson