Section access

[qliksus]

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;

[Anonymous]

Hi Qliksus,

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

[amars]

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

[qliksus]

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