topic Re: Section Access in QlikView

Section Access

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

Hello together,

I´m using section access via an excel spreadsheet to control the access permission of my users. Now I´m trying to create a new permission for one of the users:

The Person should see the SoldToBusinessPartner.ExternalSalesRepName "JW" and "CG" for Company 200 and 700. But for "JW" the person should just see the SoldToBP.Area2 "40". If I do it this way then Qlik View only shows data for SoldToBPArea2 "40" for SoldToBusinessPartner.ExternalSalesRepName "JW". It does not show any values anymore for "CG". Any idea what I´m doing wrong here?

Best regards

Carolin

Re: Section Access

carolin01 — Wed, 25 Jun 2014 11:51:19 GMT

If I delete "40" from SoldToBP.Area2 then I see both "CG" and "JW". I don´t understand this.

Re: Section Access

sasikanth — Wed, 25 Jun 2014 11:58:42 GMT

Try to keep * in SoldToBP.Area2 for reaining other than 40

Re: Section Access

yduval75 — Wed, 25 Jun 2014 12:00:37 GMT

Hello,

I think that you have to create a section access on juste one field that concatenate SoldToBusinessPartner.ExternalSalesRepName and SoldToBP.Area2

You can read this for section access on multi axe

Introduction to Section Access

Re: Section Access

carolin01 — Wed, 25 Jun 2014 12:07:45 GMT

Hi,

I entered * instead of 40. The result is that I can see all SoldToBP.Area2 values for "JW" but now values for "CG".

Re: Section Access

Wed, 25 Jun 2014 12:10:14 GMT

Hi!

Try to use 'ALL' instead of *

Re: Section Access

yduval75 — Wed, 25 Jun 2014 12:17:19 GMT

Indead, when you put * in your section access, it means all values present in your section access and not in the data model.

You have to write all values of the field SoldToBP.Area2 for "CG".

Re: Section Access

carolin01 — Wed, 25 Jun 2014 12:17:45 GMT

I concatentated so that I could enter "JW40" as value. Now I only see "JW" for "40" but still not "CG".

Re: Section Access

Wed, 25 Jun 2014 12:20:05 GMT

Or just use 'ALL' instead of '*'

Re: Section Access

yduval75 — Wed, 25 Jun 2014 12:28:29 GMT

When you put * in your section access, it means all values present in your section access and not in the data model.

You have to write all values of the field SoldToBP.Area2 for "CG".

Re: Section Access

sasikanth — Wed, 25 Jun 2014 12:32:27 GMT

SoldToBP.Area2

use like above it will work

Re: Section Access

carolin01 — Wed, 25 Jun 2014 12:40:21 GMT

'All' did not work and also * did not. I will now try to enter a value for CG checking if it is correct what Yoann says.

Re: Section Access

Wed, 25 Jun 2014 12:44:02 GMT

Can you attach an example, maybe I could help?

Re: Section Access

PradeepReddy — Wed, 25 Jun 2014 12:47:48 GMT

Why you are taking 'Company=200' for employee 'JW' 2 times, I am not clear on this?

Try something like this....

REPNAME	REGION	COMPANY	AREA2
JW	EMEA	200	40
CG	EMEA	200	*
CG	EMEA	700	*

Regards

Pradeep

Re: Section Access

sasikanth — Wed, 25 Jun 2014 12:56:07 GMT

Make star pattern like above and check the option

Initial Reduction based on the section acces(in document properties -->opening tab)

that means where ever * is there the user have accces to all values in "SoldToBP.Area2"

If you specified a value then it will resrtict the user to see only that value

Re: Section Access

mphekin12 — Wed, 25 Jun 2014 13:02:13 GMT

Carolin,

Check out this post regarding section access:

Section Access Help - Admin not seeing all data

I had a similar issues with section access and this post helped solve my issue.

Re: Section Access

yduval75 — Wed, 25 Jun 2014 13:10:59 GMT

You have to do this and add all values in AREA2 for REPNAME "CG"

REPNAME	REGION	COMPANY	AREA2
JW	EMEA	200	40
CG	EMEA	200	40
CG	EMEA	700	40
CG	EMEA	200	50
CG	EMEA	700	50

Re: Section Access

hic — Wed, 25 Jun 2014 21:13:46 GMT

It is not possible to use several reducing fields in Section Access the way you try. See http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/02/data-reduction-using-multiple-fields

HIC