Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks Deepak
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
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