Default sheet when user logs into the application

[#1]

Hi all,

I have requirement where I want to set default sheet based on user login. for eg, I have 5 sheets, sheet1,sheet2...sheet5. when user A logs in he should be able to see all sheet but default sheet should be sheet2... if user B logs in he should be able to see all 5 sheets but default sheet should be sheet3. like wise for all users

[amit_saini]

Hi,

Check:

https://community.qlik.com/message/418813#418813

Or might be you can use Section Access concept.

Thanks,
AS

[avinashelite]

How many users you have ?? if its limited 2 or 3 then you could add a trigger ..

*Document Properties

*Triggers

*On open > Add action> layout > Activate sheet > add a condition for the same

*If(OSuser()='A','SH01')

[#4]

SECTION ACCESS need to implement to your application and to show default particular sheet .....you need to make sheets to work on conditional bases like when user one login the first default sheet 2 first then remaining sheets....

[#5]

If there are more than 200 users then, will it impact the performance?

[avinashelite]

If you have more users than , you need to add a column in the script which says which sheet needs to be the default sheet for the user . some thing like this

LOAD * inline

[

User,SHEET

A,SH01

B,SH02

C,SH01

...

...

];

then based on the login user you could add a condition like

if(OSUSER()=User,SHEET)

Hope this give you some idea to handle this requirement

[Anil_Babu_Samineni]

I accept with Avinash,

But if you have more than limit users you might need this too

If(Pick(OSuser()='User1','User2','User3',Match("SH01","SH01,SH02",'SH03')))