topic Section access from table with two fields in QlikView

Section access from table with two fields

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

Hi All,

I'm trying to restrict users to only certain cost centres, and so have used the following.

this works until I try to add a section field, Expense Category, which is need to restrict some users to see all cost centres but only the training expense category.

The file looks like this, where the F codes are then used in the access tab.

Any ideas why this doesn't work with * in exp cat column apart from when training?

thanks!

Re: Section access from table with two fields

kaushiknsolanki — Fri, 21 Apr 2017 17:34:43 GMT

Hi,

Check this link.

Data Reduction Using Multiple Fields

Section Access with multiple fields

Basics for complex authorization

Regards,

Kaushik Solanki

Re: Section access from table with two fields

Peter_Cammaert — Sun, 23 Apr 2017 16:21:44 GMT

It shouldn' work at all, as the Section Access table has a field called "DATA_GROUP_Cost_Manager" that will be automatically renamed to "DATA_GROUP_COST_MANAGER" and all field values will be converted to upper case (standard Section Access behavior). But there is no such field in Section Application...