I am sorry that I have to ask you guys again but I am desperate...
Assuming I have a table like this:
Load * Inline [
AREA, COUNTRY, CUSTNO, Amount
1000, DE, 123456, 100
1100, DE, 321654, 101
1000, US, 654987, 102
1200, US, 987654, 103
(and a lot more)
and I have the following rules:
- User 1 should have access to all data and have ADMIN rights
- User 2 should have access to all records with COUNTRY = DE, independent of all other columns, and have USER rights
- User 3 should have access to all records with AREA= 1000 but NOT CUSTNO = 123456, independent of all other columns, and have USER rights
- User 4 should have access to all records with COUNTRY = DE and AREA = 1000, independent of all other columns, and have USER rights
I made it running with giving all users ADMIN rights but that of course won't work in Accesspoint (just locks out all USERs). I didn't find sufficient information about implementing section access with multiple fields and 'Jokers' and it is driving me crazy... so help would be really great! 🙂
I also didn't get that topic about <ANY> and the * .... ANY is actually no keyword which qlikview could really work with, right? it is more something like a "you don't find me", isn't it? but doesn't this lead to the lock-out when using the restrictive mode?