topic Re: Section Access in QlikView

Section Access

Wed, 14 May 2014 12:25:43 GMT

Hi all ,i have a sheet it contain 3 countries data,That countrie field places in combo box ,so here if i login as india user its possible to disply only india in combo box,please help me

Re: Section Access

Wed, 14 May 2014 12:34:33 GMT

Hi Uday,

See the vedio by fallow the link below

QlikView Security Video Series (2 of 8): Simple Row-level Security via Section Access - YouTube

Hope it helps

Regards,

Koti

Re: Section Access

crusader_ — Wed, 14 May 2014 12:44:53 GMT

Hi,

Yes, it's possible.

Make field Country for each user and include it in Section Access table.

LOAD * INLINE [

ACCESS, NTDOMAINSID, NTNAME, USERID, PASSWORD, COUNTRY

USER, *, *, *, *, 'INDIA'

];

LOAD 'USER' AS ACCESS,

'*' AS NTDOMAINSID,

'*'AS NTNAME,

'*' AS USERID,

'*' AS PASSWORD

, COUNTRY

;

SQL or xls or any source...

Hope this helps.

Kind regards,

Andrei

Re: Section Access

fkeuroglian — Wed, 14 May 2014 12:48:35 GMT

HI, you have to use DATA REDUCTION

See this and then try with this examples

QlikView Section Access Examples

Good luck

Fernando

Re: Section Access

ashfaq_haseeb — Wed, 14 May 2014 12:54:18 GMT

Check Here

If you can get the same.

Regards

ASHFAQ

Re: Section Access

Wed, 14 May 2014 12:55:43 GMT

Hi Fernando ,what am expecting is i need reduction only in combo box,help me

Re: Section Access

Anonymous — Wed, 14 May 2014 12:57:59 GMT

Try like this,

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER, SRIKANTH, SRIKANTH

USER, LEELA, LEELA

];

Section Application;

LOAD * INLINE [

USERID, pot_salesstage

SRIKANTH, Awaiting PO

SRIKANTH, Closed Lost

LEELA, Closed Won

LEELA, Lead Dead

];

Re: Section Access

Wed, 14 May 2014 13:10:05 GMT

Hi Sreekanth its for all sheet objects ,what am expecting is only for combo box,,please help me

Re: Section Access

Anonymous — Wed, 14 May 2014 13:19:12 GMT

I didn't get your requirement ..

There is no Comobobox in Qlikview.

better to Attach sample QVW

Re: Section Access

Wed, 14 May 2014 17:28:26 GMT

Its Multi box