topic Permanent Field Value Selection with Section Access in QlikView

Permanent Field Value Selection with Section Access

Anonymous — Fri, 04 Dec 2015 05:56:15 GMT

I have the following section access table:

ACCESS	USERID	PASSWORD	RETAILPHARMACY
ADMIN	CHITEMERERE CHRIS	RUVIMBO320	*
USER	TY6666	BEN55D4	MEDIX
USER	DDDDD-aa	ONESIMOS93AMG	MEDIX
USER	BNNNNNN	CAROLPSP55AMG	PSP
USER	YTRRR	NHAMO65AMGPSP	PSP
USER	UYYYYY	PRIMROSEGWS66	GREENWOOD

When a USERID opens the application and logs in, they need to have the RETAILPHARMACY field value they belong to permanently selected. For example when USERID TY6666 logs in the application, the field value MEDIX should be permanently selected. Is this possible in QV and if so how can this be accomplished?

Regards.

Re: Permanent Field Value Selection with Section Access

Chanty4u — Fri, 04 Dec 2015 06:04:29 GMT

hi,

please chk below link

Section Access

Thanks

Suresh

Re: Permanent Field Value Selection with Section Access

tresB — Fri, 04 Dec 2015 06:09:03 GMT

Document properties->Opening-> Check 'Initial slection based on section access'

Re: Permanent Field Value Selection with Section Access

Anonymous — Fri, 04 Dec 2015 07:48:53 GMT

Thank you Suresh i will have a look at the link

Re: Permanent Field Value Selection with Section Access

Anonymous — Fri, 04 Dec 2015 07:50:01 GMT

Many thanks, if i use the recommended option, i will lose my required initial data reduction based on section access

Regards

Re: Permanent Field Value Selection with Section Access

tresB — Fri, 04 Dec 2015 08:01:01 GMT

You can alternatively try triggers. OnOpen (application)->Select in field and lock field (if at all required).

Re: Permanent Field Value Selection with Section Access

Anonymous — Fri, 04 Dec 2015 12:28:42 GMT

Thanks Tresesco