Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

section access

Hello ! I've got a problem with section access. I have two lists : PRODNAME and REGION. While I execute this code

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, PRODNAME
ADMIN, user1,*
USER, user2,HAYAT
USER, user3,EVYAP
USER, user4,KALINA
USER, user5,COSMETICA
USER, user6,CONSTRMAT
USER,user7,DEFAULT
USER, user8,NEVCOSMET
USER, user9,FOOD
USER, user10,TRICOT
USER, user11,PAPER


]
;
Section Application;

It works great but when I change instead of PRODNAME to REGION it doesn't want to open if I enter as user.

What I need to change?

Thank you !

1 Solution

Accepted Solutions
avinashelite

try this

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, REGION1

    ADMIN, dcucuta, *

    ADMIN, dtest,UCRAINA

    ADMIN, dcucuta, ROMANIA

    ADMIN, dcucuta, GERMANY

    ADMIN, dcucuta, BULGARIA

    ADMIN, dcucuta, GERMANY

    user, adovbenco, CHINA

];

Section Application;

LOAD F1 as REGION,Upper(trim(PurgeChar(F1,0123456789.))) as REGION1;

LOAD * INLINE [

    F1

    03. Regiunea Nord

    05. Regiunea Transnistria

    Istanbul

    01. Municipiu Chisinau

    02. Regiunea Centru

    04. Regiunea Sud

    04 Turkey

    05 Rusia

    <NA>

    06 Bulgaria

    09 Germany

    03 Ucraina

    02 Romania

    08 Poland

    07 Azerbaidjan

    01 Moldova

    10 China

];

View solution in original post

22 Replies
vishsaggi
Champion III
Champion III

What is your LOAD statement when using REGION field in section access? Can you paste here?

denis115
Creator
Creator
Author

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, REGION
ADMIN, user1,*
USER, user2,GERMANY
USER, user3,TURKEY
USER, user4,FRANCE
USER, user5,RUSSIA
USER, user6,ROMANIA
USER,user7,SPAIN
USER, user8,NETHERLAND
USER, user9,USA
USER, user10,GB
USER, user11,AUSTRALIA


]
;

vinieme12
Champion III
Champion III

and is the Section Application also defined for REGION?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
tresesco
MVP
MVP

Have you enabled 'Strict Exclusion' ? If so, check unchecking that if opens. If opens, that means your REGION field doesn't have data for that user.

denis115
Creator
Creator
Author

Yes ! It opens with no changes I mean all REGIONS are visible for user

denis115
Creator
Creator
Author

what do you mean?

tresesco
MVP
MVP

You have to ensure that the field name and section access field are exactly same, REGION and REGIONS are different. Also make sure that you load the region data using UPPER().

avinashelite

Could you please paste the complete script ? we need to check your section application part where the actual reduction logic is defined

denis115
Creator
Creator
Author

can you look in my script please, pass for hidden script is : denis