topic How can I make this security access? in QlikView

How can I make this security access?

rcandeo — Tue, 28 Feb 2012 18:14:54 GMT

I´ve configured a security based in a section acces and it works, but I wanna make a selections using *. How can I do that?

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, SEG-TIPO

ADMIN, ADMINISTRATOR, ALL

USER, USER1, SEC1

USER, USER2, SEC2

USER, USER3, SEC3

NONE

];

Section Application;

Star is *;

LOAD * INLINE [

SEG-TIPO, TYPE

SEC1, HOUSE*

SEC2, HOUSEA

SEC3, HOUSEB

ALL, *

];

USER1 must see HOUSEA + HOUSEB

USER2 must see HOUSEA

USER3 must see HOUSEB

How can I make this security access?

erichshiino — Tue, 28 Feb 2012 18:40:35 GMT

Hi, rcandeo

You can try this:

LOAD * INLINE [

SEG-TIPO, TYPE

SEC1, *

SEC2, HOUSEA

SEC3, HOUSEB

ALL, *

];

LOAD * INLINE [

SEG-TIPO, TYPE

SEC1, HOUSEA

SEC1, HOUSEB

SEC2, HOUSEA

SEC3, HOUSEB

ALL, *

];

Hope this helps,

Erich

How can I make this security access?

rcandeo — Tue, 28 Feb 2012 18:49:53 GMT

Imagine that I have dozes of records beginning with HOUSE, and hundreds with other words. That´s why I need to user HOUSE*.

Any idea?