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.
m4u
Contributor II

Conceptual problem with Access Restriction

Hi all,

i have a qlikview report of sales. the module is based on a full outher join of the following objects:

sales documents; sales lines; items;dealers,reps and so on.

now i need to create 3 types of users:

super user - can see all of the sales data

dealer - can see all of the invoices issued for this dealer

rep - can see all of the invoices belongs to shipping sites under this rep

now, there are invoices without a "dealer" or without a "rep".

this is my code:

star is *;

Section Access;

LOAD * INLINE [

ACCESS,USERID,PASSWORD,DEALERCODE,U_REP

ADMIN,ADMIN,1,*,*

];

SELECT 'USER' ACCESS,CardCode USERID,-99999 PASSWORD,CardCode DEALERCODE,'*' U_REP FROM OCRD GROUP BY CardCode;

SELECT 'USER' ACCESS,REPLACE(U_Rep,' ','') USERID,-99999 PASSWORD,'*' DEALERCODE, U_REP FROM CRD1 WHERE AdresType='S' GROUP BY U_Rep;

Section Application;

now, because the star means - data of all other users, if i logged in with a dealer who has an invoice without a rep, thie invoice would not be shown.

i'll be happy for any idea

thanks,

Shlomo

Tags (1)
2 Replies
MVP
MVP

Conceptual problem with Access Restriction

Hi Shlomo,

I have found with Section Access that you often have to add rows to the section access that include all permutations attached to a dummy user so that the * works for other users. Also I have found that nulls can be problematic - so you probably want to replace missing dealers and reps with the text 'No Dealer' and 'No Rep' and add these values into your Section Access.

Hope that helps.

Regards,
Steve

m4u
Contributor II

Conceptual problem with Access Restriction

hi, thanks for your answer

shlomo

Community Browser