topic Re: Section Access Prob in QlikView

Section Access Prob

nikhilgarg — Fri, 04 Sep 2015 11:37:20 GMT

Hey,

I ahve created an app trying to implement section access but it is not worknig.Can someone help?

For seeing Hidden script, use password: admin

Thanks

Re: Section Access Prob

kuczynska — Fri, 04 Sep 2015 12:00:52 GMT

Do you must have your section access info in the separate xlsx, outside QlikView? Section access works fine in the below file, please use userId and password admin.

Password to your hidden script is still the same.

Re: Section Access Prob

mohammadkhatimi — Fri, 04 Sep 2015 12:13:59 GMT

Hie...

PFA..

Hope this will helps u...!!!

Regards,

Mohammad

Re: Section Access Prob

nikhilgarg — Fri, 04 Sep 2015 12:17:08 GMT

hey, i am using personla edition so cann't open file.Can you plz tell what changes you done ?

Thanks

Re: Section Access Prob

kuczynska — Fri, 04 Sep 2015 12:20:56 GMT

No problem.

Content of hidden script (add OMIT column in order to reduce access by country), I think you always must have an admin access to the app - as a user you may not be able to reload the application and basically assign section access for each user.

Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    User, Nikhil, nikhil

    User, Pradeep, pradeep

    User, Dpanshu, dpanshu

    Admin, Admin, admin

];

Section Application;

MAIN tab:

LOAD * INLINE [

    Id, Name, Country, Product, Sales

    1, a, GERMANY, MACHINE, 11

    2, b, GERMANY, FOOD, 22

    3, c, FRANCE, MACHINE, 33

    4, d, LONDON, SHOE, 44

    5, e, UK, MOB, 55

];

Re: Section Access Prob

nikhilgarg — Fri, 04 Sep 2015 12:33:00 GMT

Hey,

I got the problem.

I need to write ACCESS, USER, PASSWORD, in Capitals and it will work fine.

Re: Section Access Prob

kuczynska — Fri, 04 Sep 2015 12:35:11 GMT

Glad is working for you!

Re: Section Access Prob

kavita25 — Fri, 04 Sep 2015 12:41:57 GMT

PFA..

Your column labels should be in CAPS and also keep 1 person as ADMIN...

Once you will reload the data with all the Access as USER you won't be able to edit the hidden script....