Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
kanhomcake
New Contributor III

Section Access with Multiple Entries and Multiple Fields

hi Community,

I have this attached Section Access script and it doesn't work as I expect for CAKE user. CAKE has the access combined from DELL and ELEN users. DELL can see all products in UK and ELEN can see product "b" in any country. So I expect CAKE to see the data of any product in UK and all product "b" in any country. But what I got as a result is one unwanted record showing product "d" in DD country.

SectionAccess.jpg

User and password for admin is admin.

Anyone who can help solving this is gonna be the hero or I am misunderstanding the way Section Access works, please let me know. Thank you so much in advance for any reply

Best regards,

WV

Tags (2)
7 Replies

Re: Section Access with Multiple Entries and Multiple Fields

sundarakumar
Valued Contributor II

Re: Section Access with Multiple Entries and Multiple Fields

The issue in ur case is just bec u assign * for all projects in an external table.. This is wrong...

I understand u use a seperate table to reduce data bec of all CAPITALISATION issue. but the way u have implemetned is wrong...

Data is reduced in the part bw Section access ...... and section application

Secion access;

...

...(data reduction happens here)

...

Section application;

in the above described part as of the application that u haveve posted section access will look to select for "B" and "ALL PRODUCTS" in the field called procedure for ELEN... it will search for a string "ALL PRODUCTS" it will not return a * there. since ther is nothign in the name "ALL PRODUCTS", nothign will be selected. Change ur code accordingly , it should work...

Hope this helps..

-Sundar

kanhomcake
New Contributor III

Re: Section Access with Multiple Entries and Multiple Fields

thanks but your links don't help, thanks again anyway

kanhomcake
New Contributor III

Re: Re: Section Access with Multiple Entries and Multiple Fields

thanks but your reply doesn't help, plus I got this example (PDF attached) from one of QlikTech consultants. I also sent them a mail asking the same question, hope they will reply soon. Once they do, I'll share it here too.

thanks again anyway

abchandru
New Contributor III

Re: Section Access with Multiple Entries and Multiple Fields

did you resolved this,I also faced same issue

Re: Section Access with Multiple Entries and Multiple Fields

You cannot use multiple reducing fields in Section Access. See Data Reduction Using Multiple Fields

HIC

Re: Section Access with Multiple Entries and Multiple Fields

your logic is wrong:

USER,CAKE,CAKE,ALL PRODUCTS,UK
USER,CAKE,CAKE,B,ALL COUNTRIES

and in the section application your defining it as

PLReduce:

LOAD * INLINE [

PLREDUCE, PRODUCTLINE

ADMINGROUP, *

A1, A1

ALL PRODUCTS, *

B, B

];

CountryReduce:

LOAD * INLINE [

COUNTRYREDUCE, COUNTRY

ADMINGROUP, *

UK, UK

ALL COUNTRIES, *

];

which mean finally the CAKE has all products and all country access.

its acting according to your input