topic Reducing data with fields in QlikView

Reducing data with fields

christophebrault — Fri, 27 Jul 2012 09:27:27 GMT

Hi,

I'm working on security in an app and i have to restrict data for each users. I've used access and application section with success, but i'm facing a problem.

How can i say for a user that all values are possible for the field ? I tired * with staris function but doesn't work...

Thanks

Re: Reducing data with fields

giakoum — Fri, 27 Jul 2012 09:32:04 GMT

check out page 18 of the attached doc. * works only if ALL values are listed in the Section Access conecrning that field.

read and you wil figure it out.

Re: Reducing data with fields

Fri, 27 Jul 2012 09:43:12 GMT

I can confirm that you can use "*" with "star is *;" to say you want "every possible values".

Be sure you use CAPITALIZED letters in your groups for the "section access" part.

Section Access;
LOAD * INLINE [
    ACCESS, USERID, PASSWORD, GROUP_COUNTRY
    ADMIN , ADMIN, ADMIN, ALL
    USER, FRANCE, TEST, GRP_FR
    USER, USA, TEST, GRP_USA
    USER, ALL, TEST, ALL
];
Section Application;
star is *;
GROUP_COUNTRY:
LOAD * INLINE [
GROUP_COUNTRY, Country
ALL, *
GRP_FR, France
GRP_USA, USA
];
Country:
LOAD * INLINE [
Country, Value
France, 200
Germany, 300
Japan, 500
USA, 1000
];

---