Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rohan_mulay
Contributor

Section Access simplification possible?

Dear all,

I have a section access data where i want to make reduction on 'BranchID' field'.Suppose I have total 60 Branches in Branch Master. As in following case, UserID 'EMP\102' has access to 3 branches thus it is written thrice. Similarly, Now if I have to give some user access to 40 branches among 60 then do I have to mention that UserID in the section access table 40 times?? Is there any simpler way.?

ACCESSNTNAMEBranchID
USEREMP\1012
USEREMP\1021
USEREMP\1022
USEREMP\1023

Thanks In advance.

Tags (2)
3 Replies
Partner
Partner

Re: Section Access simplification possible?

You can load an extra field e.g. AccessGroup where you group these 40 values in one. You can then use this field (or a combination of) to give access. N.B the field names and values need to be in capitals, so BRANCHID

rohan_mulay
Contributor

Re: Section Access simplification possible?

Hi Piet,

Thanks for ur response.. can you please give a sample code for the same.?

Partner
Partner

Re: Section Access simplification possible?

Something like (by heart, I don't have qv available right now)

Section Access;

ACCESSNTNAMEPASSWORDBRANCHIDACCESSGROUP
USEREMP\101*2*
USEREMP\102**GROUP123

Section Application;

Load

...

BranchId as BRANCHID,

if(Num(BranchId)<4,'GROUP123') as ACCESSGROUP,

...

From....

Instead of the if statement you can maybe better use an Applymap of a previous mapping load where you map al the branchid's to a certain group.

Hope that helps,

Piet Hein