topic Re: Section Access with Multiple Entries and Multiple Fields in QlikView

Section Access with Multiple Entries and Multiple Fields

kanhomcake — Mon, 22 Sep 2014 13:33:06 GMT

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.

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,

Re: Section Access with Multiple Entries and Multiple Fields

ashfaq_haseeb — Mon, 22 Sep 2014 13:37:33 GMT

Hi,

Check this

http://community.qlik.com/docs/DOC-5973

http://community.qlik.com/docs/DOC-4435

http://community.qlik.com/docs/DOC-6331

http://community.qlik.com/docs/DOC-5917

Regards

ASHFAQ

Re: Section Access with Multiple Entries and Multiple Fields

sundarakumar — Mon, 22 Sep 2014 13:53:28 GMT

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

Re: Section Access with Multiple Entries and Multiple Fields

kanhomcake — Tue, 23 Sep 2014 04:46:08 GMT

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

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

kanhomcake — Tue, 23 Sep 2014 04:55:59 GMT

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

Re: Section Access with Multiple Entries and Multiple Fields

Anonymous — Tue, 22 Sep 2015 10:18:26 GMT

did you resolved this,I also faced same issue

Re: Section Access with Multiple Entries and Multiple Fields

hic — Tue, 22 Sep 2015 10:27:10 GMT

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

avinashelite — Tue, 22 Sep 2015 11:11:05 GMT

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