Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Luminary
Luminary

Section Access

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:

Screenshot2.png

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

17 Replies
Luminary
Luminary

Re: Section Access

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

sasikanth
Valued Contributor III

Re: Section Access

HI

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

yduval75
Contributor III

Re: Section Access

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

Luminary
Luminary

Re: Section Access


Hi,

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

Not applicable

Re: Section Access

Hi!

Try to use 'ALL' instead of *

yduval75
Contributor III

Re: Section Access

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".

Luminary
Luminary

Re: Section Access

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

Not applicable

Re: Section Access

Or just use 'ALL' instead of '*'

yduval75
Contributor III

Re: Section Access

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".


Community Browser