Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section Access on multiple fields and 'Jokers'?

Hi there,

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! :-)

Thanks a lot in advance.

Kind regards,

Martin

4 Replies

Re: Section Access on multiple fields and 'Jokers'?

Maybe this blog post helps


talk is cheap, supply exceeds demand
Not applicable

Re: Section Access on multiple fields and 'Jokers'?

Thanks Gysbert, for the link. But how would this way work in restrictive mode with users in USER-mode?

thx,

martin

Not applicable

Re: Section Access on multiple fields and 'Jokers'?

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?

Not applicable

Re: Section Access on multiple fields and 'Jokers'?

Hi,

has perhaps someone a new idea or can give me another hint?

Kind regards,

Martin

Community Browser