topic Section Access in QlikView

Section Access

carolin01 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Section Access

Fri, 23 May 2014 12:13:19 GMT

Hi Carolin,

Yes you can use your suffixe to identify a group

so you can set

UserID, GroupId, Login, Password....

best regards

Chris

Re: Section Access

fkeuroglian — Fri, 23 May 2014 12:42:29 GMT

Hi, see this attached

Good Luck

Fernando

Re: Section Access

hic — Fri, 23 May 2014 16:04:38 GMT

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