topic Re: Login issue in QlikView

Login issue

svsudhakar — Mon, 26 Jan 2026 18:19:17 GMT

Hi ,

I have developed one dashboard with Section access. Am able to access the application with my id in server, once published the same app I am getting don't have permission error.

I have an license and configured my id in the section script also.

Kindly help on this issue.

thanks in Advance,

Regards,

sudhakar

Re: Login issue

chiru_thota — Fri, 28 Feb 2014 16:42:40 GMT

Hi,

Are you able to access the same application from access point if you remove section access code ?

Re: Login issue

Peter_Cammaert — Fri, 28 Feb 2014 17:00:18 GMT

You must be using the NTNAME field in your section access table. Did you enter your credentials as domainname\username ?

Peter

Re: Login issue

svsudhakar — Fri, 28 Feb 2014 17:00:49 GMT

yes..am able to access the same application with out section access..

Re: Login issue

svsudhakar — Fri, 28 Feb 2014 17:05:27 GMT

i have used the NTNAme filed in my script. i have given access to particular users based on their Ad Id's

like Domain name\ADID.... but i didn't given the password's.

Re: Login issue

chiru_thota — Fri, 28 Feb 2014 18:10:01 GMT

I guess paswword is not required if we use windows authentication.

Some thing must be wrong with your code or QEMC settings.(Ex: All authenticated etc)

Some times order of the tab (with script code ) also create problems.I had this issue.

Can you post your sample code here ?

Re: Login issue

gainkarthi — Fri, 28 Feb 2014 19:10:02 GMT

Sudhakar,

Give admin rights to the service account (Qlikview service account) in your section access table. Run the task and see if your access is permitted.

Regards,

Karthi

Re: Login issue

Anonymous — Fri, 28 Feb 2014 19:16:29 GMT

Hi Sudhakar,

Can you post sample script.

Re: Login issue

svsudhakar — Mon, 03 Mar 2014 05:28:25 GMT

Please find the below sample script. which I have implemented

Section Access;
LOAD * INLINE [

    ACCESS, NTNAME, %SBU, %LOB, %REGION
    ADMIN, Domain\zzzz,ALL,ALL,ALL
    ADMIN, Domain\yyyy,ALL,ALL,ALL
    ADMIN,Domain\XXXX,ALL,ALL,ALL
];
Section Application;

LOAD * INLINE [
    SBU, %SBU
    AA, ALL_AA
    Others, ALL_OTHERS
    GM, ALL_GM
    Go., ALL_GO
    HL, ALL_HL
    EN, ALL_EN
];
LOAD * INLINE [

    LOB, %LOB

    A, ALL_A

    B, ALL_B

    C, ALL_C

    D, ALL_D

    E, ALL_E

    F, ALL_F

];

LOAD * INLINE [

    Region, %REGION

    West, ALL_WEST

    South1, ALL_SOUTH1

    Gulf, ALL_GULF

];

Re: Login issue

chiru_thota — Mon, 03 Mar 2014 05:39:21 GMT

remove % from section access columns.it did not work for me in our application

Re: Login issue

Peter_Cammaert — Mon, 03 Mar 2014 09:53:19 GMT

Also, the 'ALL' value in your three section access fields doesn't link to anything because it is a distinct but meaningless value to QlikView. Replace it with a *, and put the following statement before your section access LOAD statement:

STAR IS *;

Keep in mind also that if you are defined as ADMIN in section access, you will always be able to open a QVW document in desktop because the data reduction rules are partially switched off. In the AccessPoint however, this nice trick won't work and you will be treated as any other USER.

Best,

Peter

Re: Login issue

Anonymous — Mon, 03 Mar 2014 11:04:45 GMT

HI Sudhakar,

Replace All with * and use STAR IS *;

As per my knowledge even * includes only values in Section access code and there are no values other then * in access section.

For Ex:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN,

USER, USER1, U1, AFRICA

USER, USER2, U2, AMERICA

USER, USER3, U3, ASIA

USER, USER4, U4, EUROPE

USER, USER5, U4, AMERICA

USER, USER5, U5, *

];

Section Application;

SALES:

LOAD * INLINE [

REGION, PROFIT

AFRICA, 1000

AMERICA, 2000

ASIA, 3000

EUROPE, 4000

OCEANIA, 5000

];

USER5 will be able to see all regions listed in the reduction field REGION except for

OCEANIA.

Even if USER5 has “*“ for the REGION reduction field, star means “all listed values”

not all values for the field. Since no USER has OCEANIA listed for the REGION field,

USER5 will not have access to the values for OCEANIA.

If we want USER5 to see OCEANIA as well, we need to add an extra line in our section

access solution

USER, USER5, U5, OCEANIA

Hope this helps.

Re: Login issue

svsudhakar — Mon, 03 Mar 2014 12:10:29 GMT

I have removed the %columns from Section Access and replaced the All with *.

now its working fine.

thank you

Re: Login issue

svsudhakar — Mon, 03 Mar 2014 12:10:43 GMT

I have removed the %columns from Section Access and replaced the All with *.

now its working fine.

thank you