topic Re: Issues in Section Access in QlikView

Issues in Section Access

bimala0507 — Wed, 08 Jul 2015 06:41:38 GMT

Hi Qlik experts:

I am trying to apply Section Access with filter criteria like USER1 with USER ACCESS can see Data of Country CHINA, USER2 can see the Data of the Country INDONESIA and ADMIN can see everything. To my surprise, when I include the COUNTRY filter Section Access doesn't work, when I open the document it does not even ask for the password. Can anyone throw some light on this issue? Appreciate a quick reply.

Section Access;
LOAD * INLINE [
ACCESS,USERID,PASSWORD,COUNTRY
ADMIN,ADMIN,ADMIN,
USER,U1,U1,CHINA

USER,U2,U2,INDONESIA ];

Section Application;

Kind Regards,

Bimala

Re: Issues in Section Access

Siva_Sankar — Wed, 08 Jul 2015 06:49:19 GMT

Once you reload the file, you have to close the qlikview instance by closing it completely and then re open it.

I tried your code and it works for me.

find the attachment

Re: Issues in Section Access

jagan — Wed, 08 Jul 2015 06:50:41 GMT

Hi Bimala,

Please check below URL how it helps you.

Authentication and Authorization in Qlikview

Regards,

Jagan.

Re: Issues in Section Access

Kushal_Chawda — Wed, 08 Jul 2015 06:54:07 GMT

Have you checked the below option?

Go to document properties -> Opening tab -> check Initial data reduction based on Section acess

Re: Issues in Section Access

bimala0507 — Wed, 08 Jul 2015 06:54:42 GMT

Yes I have done that option

Re: Issues in Section Access

avinashelite — Wed, 08 Jul 2015 06:57:00 GMT

Hi Bimala,

have you checked initial data reduction in the document properties >open > check the initial data reduction.

And in the section application you need to have the code for data reduction, section access for accessing the document and section application for the data reduction

try like this

Section Application;

LOAD * INLINE [
COUNTRY
CHINA

INDONESIA

];

Re: Issues in Section Access

Siva_Sankar — Wed, 08 Jul 2015 06:57:03 GMT

If the file is not prompting the password, it means that you have to close the qlikview instance and reopen the application itself not just the file.

If the file is having data and if the data is not reducing as per the section access then you need to Go to document properties -> Opening tab -> check Initial data reduction based on Section acess

Based on your query, since it is not promting the password, you close the entire qv application and re-open it

Re: Issues in Section Access

jagan — Wed, 08 Jul 2015 07:02:07 GMT

Hi Bimala,

Did you checked the sample link I shared? That solution will suits for your requirement, you need to REDUCTION in your section access script.

Regards,

Jagan.

Re: Issues in Section Access

bimala0507 — Wed, 08 Jul 2015 07:08:17 GMT

Thank you so much. It is working fine. I was not closing the instance all the times.

Kind Regards,

Bimala

Re: Issues in Section Access

Siva_Sankar — Wed, 08 Jul 2015 07:10:28 GMT

If you only use the Desktop, save and exit any QlikView instance and reopen the application. If you want to check all profiles you'll need to sign out of Windows and sign in as the profile's user. You'll probably have to copy the file into a usb in order to open it in all the Windows accounts.