Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
j_cabrera
Contributor II

Section Access por PESTAÑA O HOJA HELP!!!!!/Tabbed Sheert Section Access HELP!!

hola buen dia quisiera saber si pueda aplicar el Section Access por hoja, ejemplo en mi reporte tengo 10 hojas pero  de ellas solo quisiera que sierto usuarios vean ciertas PESTAÑAS, emeplo UMEXPRI--- SOLO QUIERO QUE VEA LA PESTAÑA 1 Y LA 5 EJEMPLO NO SE SI SE PUEDA. Y SI SE PUDIERA ME PODRIAN DECIR COMO ??????

**********************

hello good day I wonder if I can apply the Section Access per sheet, example in my report I have 10 sheets but they only want users to see certain EYELASHES desert, UMEXPRI Job Information --- JUST WANT SEE TAB 1 AND 5 EXAMPLE NO IF YOU CAN. AND IF I COULD TELL ME HOW COULD??????

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, FAMILIA

    ADMIN, ADMIN, ADMIN, *

    USER, UMEXGMP, @BELTRAN1, UMEXGMP

    USER, UMEXVER, FT@LAVERA2, UMEXVER

    USER, UMEXOTE, CG@LINA3, UMEXOTE

    USER, UMEXPRI, JLIN@S4, UMEXPRI

    USER, UMEXIST, M@VILA5, UMEXIST

    USER, UMEXHES, CMOR@LES6, UMEXHES

    USER, UMEXDIR, 7, UMEXDIR

    USER, MERIDA, 8 , MERIDA

    USER, GUADALAJARA, 9, GUADALAJARA

    USER, MONTERREY, 10 , MONTERREY

];

Section Application;

Section Application;

FAMILIA:

LOAD * INLINE [

FAMILIA, PROFIT

UMEXGMP, 1000

UMEXVER, 2000

UMEXOTE, 3000

UMEXPRI, 4000

UMEXIST, 5000

UMEXHES, 6000

];

PESTAÑAS.png

1 Reply
Employee
Employee

Re: Section Access por PESTAÑA O HOJA HELP!!!!!/Tabbed Sheert Section Access HELP!!

On Sheet properties - General you have a control called "Show sheet". If you set this to "Conditional" and use the following function, the sheet will disappear for the non listed FAMILIA.

Match(FAMILIA,'UMEXGMP','UMEXHES')

HIC

Community Browser