topic Section access in QlikView

Section access

qliksus — Mon, 05 Apr 2010 08:00:52 GMT

Hi guys,

i am using a normal section access query for example

section

load * inline

[UserID,DEPT,Access

John,FINANCE,Admin ] ;

so when i login i want qlikview to ask two filters userid,dept but qlikview

is asking only useerid so please tell me how can i acheive the above mentioned two filters

access;

Section access

Anonymous — Mon, 05 Apr 2010 08:15:48 GMT

Hi Qliksus,

That won't work unfortunately. The only fields that Section Access prompts the user for are USERID and PASSWORD.

Section access

amars — Mon, 05 Apr 2010 08:18:14 GMT

Hi,

The Default nature of Qlikview is to ask for UserID and Password. Since in your section access you have put just UserId it is just asking for that. What u can do is just use Password and have the same values as Dept for it. So it will start asking for password. and according to the password u put in it will reduce the data for the Department. Or if u don't want to do that & u have the list of NT Domain name ID for each user with u . you can put NTName & Dept in ur section access so it won't ask for userID & password but it will redue data based on the Windows NT identity.

With Regards

Amar

Section access

qliksus — Mon, 05 Apr 2010 08:33:56 GMT

Thanks for the reply but i want the filter to ask for the department not password or NT domain i can do this with MACRO i just explored for other possiblity it looks like it cant be done the way i am asking