section access

[denis115]

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 !

[avinashelite]

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

[denis115]

I've send my file

[denis115]

pass for hidden script : denis

[avinashelite]

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 

[denis115]

Is this ok now?

[avinashelite · Accepted solution]

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

];

[denis115]

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?

[avinashelite]

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

[denis115]

thanks a lot!!!

[denis115]

can you explin me please this row :

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