Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carolin01
Luminary Alumni
Luminary Alumni

Section Access

HI,

I´m using a section access to assign permissions via an excel Spreadsheet to users. Now I´m wondering if it is possible to do the following:

I´ve field "SoldToBusinessPartner" that contains customer numbers. Our customer numbers from different production sites start with a different number range, e.g. 2000XXXXX or 26000XXXXX. Now I would like to know if it is possible to assign a permission to a user using the field "SoldToBusinessPartner" and assign him all customers that start with 2000*. I tried to use just 2000* in my excel spreadsheet but that was not the solution. Does anybody know how to do this?

Best regards,

Carolin

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

I would define the Customer groups in the Customer table, for instance through

     Left(CustomerNumber, 5) as CustomerGroup

and then use this new field CustomerGroup in my Section Access.

I don't know what the logic is around the number ranges, but either the above or something similar to

     Left(CustomerNumber, Len(CustomerNumber)-6) as CustomerGroup

should probably do the trick.

HIC

View solution in original post

3 Replies
Not applicable

Hi Carolin,

Yes you can use your suffixe to identify a group

so you can set

UserID, GroupId, Login, Password....

best regards

Chris

fkeuroglian
Partner - Master
Partner - Master

Hi, see this attached

Good Luck

Fernando

hic
Former Employee
Former Employee

I would define the Customer groups in the Customer table, for instance through

     Left(CustomerNumber, 5) as CustomerGroup

and then use this new field CustomerGroup in my Section Access.

I don't know what the logic is around the number ranges, but either the above or something similar to

     Left(CustomerNumber, Len(CustomerNumber)-6) as CustomerGroup

should probably do the trick.

HIC