topic Re: set the access by two dimensions in QlikView

set the access by two dimensions

Anonymous — Fri, 19 Jan 2018 02:36:11 GMT

HI guys,

I have met a problem when I set the access of user

we have a plant in each state, NY, NJ and CA. Each plant could produce PC and MOBILE.

there is a user only want the access of NY's PC&MOBILE, NJ's PC&MOBILE and CA's PC. how could I do this?

MANY THANKS

uacg0009 — Fri, 19 Jan 2018 07:48:28 GMT

Hi Glen,

Please try like this:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, STATE, PRODUCT

USER, AAA, NY, PC

USER, AAA, NY, MOBILE

USER, BBB, NJ, PC

USER, BBB, NJ, MOBILE

USER, CCC, CA, PC

];

Section Application;

Thanks.

Aiolos

Anonymous — Fri, 19 Jan 2018 10:17:39 GMT

Hi Aiolos,

It doesn't work..

I have tried this and the result is that I have the full access..

uacg0009 — Fri, 19 Jan 2018 10:58:54 GMT

Hi Glen,

Please make sure your column name is also upper case, and try again.

And don't forget to select the checkbox on Document Properties.

Thanks.

Aiolos