Open Qlikview different sheets depending on user

[#1]

Hi

I want to know wheter it is possible to have a qlikview cloud open on a certain sheet depending on the user who opens the qlikview cloud

I have two users 'TSC' and 'RS'

1) Upper(OSUser())='TSC'

2) Upper(OSUser())='RS'

When TSC opens my Qlikview cloud i want that Qlikview opens on the sheet 'Retail'.

When RS opens my Qlikview cloud I want that Qlikview opens on the sheet 'Sales'

Yet both have to be able to see both sheets.

[RonaldDoes · Accepted solution]

Hi Tim,

I would suggest using a document action to activate the correct sheet.

• Open document properties (Settings -> Document Properties)
• Open tab Triggers
• Choose OnOpen in Document Event Triggers
• Choose Add Actions (or Edit Action(s) if you've already got actions defined)
• Select Add
• Under Layout, choose Activate sheet
• For Sheet ID, enter =If(Upper(OSUser())='TSC', 'Retail', 'RS')

Check that the sheet ID's (not the names) are to be used here.

Hope this helps you.

Kind regards,

Ronald

[prieper]

you may put this as trigger in Document Properties -> Triggers -> Document Event Triggers -> On Open.

Peter

[tresesco]

On Open -> Activate Sheet: