topic Re: section access in QlikView

section access

denis115 — Wed, 25 Nov 2020 16:16:04 GMT

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 !

Re: section access

vishsaggi — Tue, 29 Aug 2017 14:56:47 GMT

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

Re: section access

denis115 — Wed, 30 Aug 2017 05:02:39 GMT

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

];

Re: section access

vinieme12 — Wed, 30 Aug 2017 05:10:55 GMT

and is the Section Application also defined for REGION?

Re: section access

tresB — Wed, 30 Aug 2017 05:12:16 GMT

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.

Re: section access

denis115 — Wed, 30 Aug 2017 05:45:26 GMT

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

Re: section access

denis115 — Wed, 30 Aug 2017 05:45:45 GMT

what do you mean?

Re: section access

tresB — Wed, 30 Aug 2017 05:49:28 GMT

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().

Re: section access

avinashelite — Wed, 30 Aug 2017 06:02:51 GMT

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

Re: section access

denis115 — Wed, 30 Aug 2017 06:03:57 GMT

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

Re: section access

avinashelite — Wed, 30 Aug 2017 06:08:50 GMT

Please comment the section access part and share the app/script we are not able to open the app

Re: section access

denis115 — Wed, 30 Aug 2017 06:11:22 GMT

I've send my file

Re: section access

denis115 — Wed, 30 Aug 2017 06:25:14 GMT

pass for hidden script : denis

Re: section access

avinashelite — Wed, 30 Aug 2017 06:26:17 GMT

Yes but your using the NTNAME which will not allow us to login to your app ....comment the section access part and reload the file and then share the file

Re: section access

denis115 — Wed, 30 Aug 2017 06:29:41 GMT

Is this ok now?

Re: section access

avinashelite — Wed, 30 Aug 2017 06:37:14 GMT

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 [

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

];

Re: section access

denis115 — Wed, 30 Aug 2017 07:04:23 GMT

It's working! thanks! but why is so complicate? why we can't only modify some words in this script?

like instead of prodname just to put region and add sections of this group?

Re: section access

avinashelite — Wed, 30 Aug 2017 07:12:46 GMT

no its doesn't work like that ...

1.Qlikview links the tables using common keys so having the right column name is most important

2.Data format/type should be same then only its will reduce the data . remember Germany and GERMANY are treated different in QV

Re: section access

denis115 — Wed, 30 Aug 2017 07:18:01 GMT

thanks a lot!!!

Re: section access

denis115 — Wed, 30 Aug 2017 08:22:35 GMT

can you explin me please this row :

Upper(trim(PurgeChar(F1,0123456789.)))